Do you know how to add minicharts to Qlik Sense tables

May 29, 2017
Written by

Can you make sense of Qlik Sense? A few days ago Arturo Muñoz stumbled upon one of those little tricks that we all love. Roland Vecera came up with a nice solution to bring mini charts to Qlik Sense. It can help us to increase app data density and make our Qlik Sense tables sexy and informative again. Don't forget to add this to your bookmarks![rd_line line_pos="center" margin_top="10"][rd_images_gallery images="25163"][rd_line line_pos="center" margin_top="10"]In Roland's blog post you will find instructions on how to build a linear gauge, a traffic light gauge, and even whiskers minicharts (right table in the image above),

I particularly like the linear gauge, with this technique we can now simulate small bars that go along with each one of the table dimension items. The expression used to create the linear gauge 'bar chart' is actually reusable and very simple, looks like this:

repeat('█', rangemax(rangemin( ceil(((column(1)/column(2))-1)*10),10),1) )

The expression will paint a variable number of solid blocks █ based on a given calculation that is evaluated by row. By now you should have a nice grey bar from 1 to 10 blocks.

Next (optional) step is to apply colour to it. You could add colour based on any criteria you want, in the chosen example Roland is using colour in the same way as he uses size, both display Growth.

The text color expression looks like this in the example:

 

if(expression>2, argb(255,0,150,0),

if(expression>1, argb(255,0,200,0),

if(expression>0.5, yellow(),lightred())))

 

Where expression will be the same expression as in Growth column (Steigerung).

You can read more about minichars in tables trick at QlikView + Qlik Sense Blog von Heldendaten: Qlik Sense Calendar Measures & "Minicharts" in Tabellen

Hope you like it.

 

Posted by Arturo Muñoz in Qlik Design Blog on Apr 21, 2017 8:06:16 AM

SHARE ARTICLE