qlik sense consultant Tag dimensions and measures in Qlik Sense to help users The dimensions and measures library has a really handy search function to help end users find fields and measures that they want to drag onto a visualisation. Sometimes the fields are not in
Dimensions and measures What is the difference between dimensions and measures in Qlik Sense? If you have just started using Qlik Sense then you may be confused about what exactly the difference between a dimension and measure is in Qlik Sense or Qlikview. Any visualisation can be
date and time functions Correctly format a date from a string in Qlik Sense using MakeDate function Sometimes you get some data and the dates are just not right. They are stored as text or as a string or in some wierd format that you just don’t know what
Qlik Sense Consulting Split a string into seperate fields using the subfield function in Qlik Sense Subfield() is a great function for splitting a long string into seperate fields. You can use this to split out a date or anything where you have a common delimeter in a string.
Load Script What is a QVD file in Qlik Sense and how do I use it? A QVD (QlikViewData) file is a file containing a table of data exported from Qlik. QVD is a native Qlik Sense and Qlikview format and can only be written to and read by
Qlik Sense Using Qlik Sense to connect to a web API with dynamic URLs If you want to bring in data from a web API then this can be done with Qlik Sense out of the box. Go to data connection library as shown below. click on
Qlik Sense Consulting Qlik Sense high vis mode Maybe you need to see your dashboard in bright high visiblity colors? When accessing a Qlik Sense dashboard through your browser just put theme/highvis at the end when your on a sheet.
Qlik Sense Consulting Put non standard Characters inside Qlik Sense Using char() If you have a need to put rare characters into Qlik Sense this can be done inside objects using the Char() function. http://www.yellowpipe.com/yis/tools/ASCII-HTML-Characters/
Qlik Sense Consulting Create a custom Current Selections Bar in Qlik Sense You may be comfortable with the Qlik Sense default current selections box: What if you or your end users aren’t keen on the look and feel? Especially inside a web application you
Qlik Sense Consulting Select searchable fields in Qlik Sense Global Search So this is something new in Qlik Sense that you can do with the load script. If you are familiar with Qlikview you will be aware of the search object and the ability
Extensions Branded templates for Qlik Sense in Workbench editor This is a great example of using workbench editor to get the most out of Qlik Sense and achieve things that no other product(including Qlikview) can with drag drop functionality for users
Qlik Sense Consulting Qlik Sense Web Applications Quick start HTML layouts to get your Qlik Sense web application looking good quickly You don’t need to be an expert in web devleopment to throw together some stunning web based dashboard using Qlik Sense. There are loads of websites that give free HTML5 layouts that
Qlik Sense Consulting Introduction to Git for Qlikview people Basically Git is change control for your working directory. It is platform independent, you can install it on Windows, Linux, Mac whatever… and these people will all be able to work together using
Qlik Sense Consulting Introduction to Bootstrap for Qlikview people This post may be of interest to you if you want to do a branded layout in Qlik Sense. With Qlikview it was very easy to throw a layout together and use show
qlik sense consultant What is a mashup? A **mashup ** is a web page that uses content from more than one source to create a single new service displayed in a single graphical interface. In the context of Qlik this means
Qlik Sense Consulting Heroku and Qlik Sense - A great combo for hosting analytics mashups Before we start please note the below is my own opinion and is in no way endorsed by Qlik as a company. Follow at your own risk :). The aim of this post is
Qlik Sense Consulting How to find Qlik Sense object IDs You can quickly find Qlik Sense object IDs by visiting http://localhost:4848/single.html This can save lots of time!!
Qlik Sense Consulting Creating a combined Qlikview and Qlik Sense access point In places where Qlikview is already alive you may want to give your users a single place for them to access both types. This can be done using this project on Qlik Branch:
Qlik Sense Consulting Qlik Sense D3 Visualisation Example Library Here are some great examples of D3 inside of Qlik Sense: http://sense.axisgroup.com/sense/app/1dadc9e8-d2f5-47f8-ad21-a2209257cc20/sheet/xtcwya/state/analysis This is the github repository: https://github.com/skokenes/Qlik-Sense-D3-Visualization-Library This
Qlik Sense Consulting Do a fuzzy search on a value with Qlik Wildmatch function There are lots times in Qlik Sense and Qlikview where you want to be able to search a value for a particular string. Some people might call this semantic analysis, some people might
Qlik Sense Consulting Qlik Sense class function The class function enables you to group numeric values into buckets that you can then use as a dimension in a chart. Imagine you have the following data table: NameAgeBob32Ellie55Fred5Steve20Say you want to
Qlik Sense Consulting Authenticate Qlik Sense in a nodeJS + express app on an external web host Note: This is all my own opinion and in no way is endorsed by Qlik. Use at your own risk!! Why would you want to do this? ExpressJS is one of the most
Qlik Sense Consulting Simple mashup user access permissions A simple way to think about a mashup is as an extension of the particular Qlik Sense application you have embedded. If a user does not have access to the application inside a
Qlik Sense Consulting Qlik Sense Workbench dev-hub location and other mashup links for developers To normal mortals like me it took a while to work out how to actually access the Qlik Sense Workbench in Qlik Sense Desktop. At this time it is not a separate product