Tips and Tricks for Qlik Sense (part 2)
Monday, 15 November, 2021

Here, are some of the many tips and tricks that you can implement in your Qlik Sense applications. The goal is to show you tips that can make your job easier and to highlight features that are not intuitive to find. The most anticipated article is here to make your job routine easier. So, let's start! 

5. Add a description to a chart 

One of the best practices when creating a Qlik Sense application is to add a description to charts and tables to understand how the result was achieved and give a clear and detailed definition of the indicator. For example, if you calculate the following indicator: Number of active customers. It is interesting to describe the notion of the active customer to avoid ambiguity. In Qlik Sense, the easiest way to add a description to an object is to turn it into a Master Item and then add a description in the settings of the Master Item. 

Once added, you will see an icon appear in the form of an “i” that displays the object’s description. 

Here’s how to do it: 

Image 2

Edit the Master Item and add a description (Image 2) 

%Qlik Sense Reporting Tool & Alternative to NPrinting%Qalyptus

Image 3

Use the master item in a sheet. Edit it and Switch On “Show details.” (Image 3) 

Image 4

Now you can see the “Show details” button (Image 4)

6. Scramble your sensitive data in Qlik Sense 

Sometimes, you want to send a Qlik Sense app outside of your organization, and you don’t want others to access the information in the app. In QlikView, there is a feature that allows you to choose which fields to scramble, and QlikView transforms the values ​​of these fields into text and numbers, which are random. Unfortunately, data scrambling is not available as a feature in Qlik Sense at this time. 

Here is a post that explains how to scramble fields using an Excel file to specify the fields to scramble and a Qlik script that will automatically scramble the fields. 

7. Customize a Qlik Sense object with CSS 

Graphical user interface, applicationDescription automatically generated

Image 5

This tip is for the smartest developer. As you know, Qlik Sense is a full web tool, which says web means HTML / CSS. If you want to customize a Qlik Sense object and don’t have the necessary functionality in the object’s settings, you can embed CSS code in your sheet and change the style of the object. To achieve this, you would have to go through the “Multi KPI” object in the built-in extensions of Qlik Sense. This object contains a text box where you can enter your CSS code (Image 5). To see in detail how to do this, Christof Schwarz made a very good video where he explains how to change a simple table and a pivot table. 

See the video: Styling Sense Tables with Properties and CSS 

To be continued...

For part one click here!

Christos Ksidias, Data Visualization Engineer, WITSIDE


Share to
<- View all articles

AI in Action: Download Form

Blog Post Questionnaire