At Qonnections 2019 I hosted a session called “Qlik Sense Visualizations, best practice and top tricks”. I have received a lot of positive feedback, so I decided to make a part 2 with 41 more or less useful new tips.
Recent feature additions to Qlik Sense have certainly helped to expand the possibilities of customizing Sense, such as the container object, the dashboard bundle, alternate states, show conditions to name a few. But it’s also the power of the calculation engine and the expression language that many times provides a way forward tweaking the look and feel of Sense.
Most of the tips I will share in this post are invented by others and have been published before on Qlik Community. I highlighted some examples below, but there are many more tips included in the app.
Bars and sparklines in the straight table
Pad with Unicode white breaks, add a center line and use the absolute max as denominator. Showing two version, plain bars and circles, filled or empty. Sparklines are covered in the first set of tips.
Vertical filter pane with values
Use the filter pane one grid high and change the label hold all values =concat(distinct Year,' | ').
Different markers per line
Add two measures, one for line and one for the symbol. Use master measures to keep colors consistent.
Chart with annotations
Use the combo chart and custom marker layers on a secondary axis. Add a custom expression for the marker and the label. Tweak the axis and the expression to get the markers on the right place.
Create a copy of the combination field in the load script, in this case, ProductNames. Add to a pivot table, use count(OrderID) as measure, mask duplicates values with white text color. Credit: Swuehl, link to post.
This is a strict Venn diagram with all areas always present. Use an image of Venn diagram and the area layer of the map chart. Check out how to make a clickable chart of an image.
Line chart with colored bands
Can be made with the line chart in area mode with measures for the bands. Create a line chart, set to area mode, unstacked. Add master measures for the bands with the wanted color. Add master measure for actual. Add measures to chart, starting with actual and the bands in progressive order. Add reference lines for the bands with label and color.
Vertical band chart
Create bar chart, Add measure =1 label =' '. Color by the wanted measure, add label. Switch of axis, labels and value. Set number of bars to "Max". Set bar width to max in "Styling". Add legend at the bottom. Switch of legend title.
Download the app
Full instructions and working examples can be found in the app below. Some of the tips are very easy to implement while others require a little more work. Most of them are independent of the Qlik Sense version but I recommend using the latest version.