article Top 10 Viz tips - Qonnections 2019 - Part I in Official Support Articles

Top 10 Viz tips - Qonnections 2019 - Part I

Patric_Nordstrom — Mon, 20 Apr 2026 08:35:40 GMT

At Qonnections 2019 I hosted a session called "273367 Qlik Sense Visualizations, best practice and top tricks". Here's the app I used with all tips including test data. Tip titles, more details in app:

* Chart and UI *
Butterfly chart
Gantt chart
Grid chart
Dynamic charts
Map image background
Previous/next in selection
Cyclic groups
Dividers
Date search filters
Dynamic bookmark
Select null

* Add ons *
Above and below
Color above average
Bell curves
Trendlines
Accumulation
Top 5 lines
Offset measures

* Table *
Custom report
Change null color
Sum with null
Subtotals and empty rows
Indentation
Indicators and symbols
Traffic lights
Pajama striping
Sparklines
Link to app

There is also video available: https://www.youtube.com/watch?v=fIOcb_JGNb4&t=3s

I want to emphasize that many of the tips are discovered by others than me, I tried to credit the original author at all places when possible. Many of the tips have been published before on the Qlik Community, the app below can be viewed as my current top picks.

If you liked it, here's more in the same style:

24 days of visualization Season III, II, I
Top 10 Tips Part X, IX, VIII, VII, VI, V, IV, III, II , I
Let's make new charts with Qlik Sense
FT Visual Vocabulary Qlik Sense version
Similar but for Qlik GeoAnalytics : Part III, II, I

Thanks,
Patric

Re: Top 10 Viz tricks - Qonnections 2019

paulcalvet — Wed, 15 May 2019 08:18:38 GMT

Excellent !

This application is a must have 😀

Paul

Re: Top 10 Viz tricks - Qonnections 2019

luiskeyrus — Fri, 24 May 2019 08:53:32 GMT

Thanks!

Re: Top 10 Viz tricks - Qonnections 2019

lironbaram — Sun, 26 May 2019 12:32:14 GMT

HI Patric

great app ,

thanks for sharing

Re: Top 10 Viz tricks - Qonnections 2019

melisa_tesillo — Mon, 27 May 2019 02:36:55 GMT

Thanks for sharing Patric!!

Re: Top 10 Viz tricks - Qonnections 2019

yossefsalomao — Sun, 16 Jun 2019 01:49:34 GMT

Thank you

Re: Top 10 Viz tricks - Qonnections 2019

deepika_gohil — Tue, 18 Jun 2019 05:08:02 GMT

Hi Patrick,

Thank you so much for sharing such valuable applications.

our requirement is we needed value and traffic indicator in the same column. In the Actual column, we need an indicator if the value is positive then the indicator will be green and vice a versa.

We are trying to implement the traffic indicator in the pivot table and below is the issues:

1) Even if we try showing the indicator in the next column but we are not able to resize the column width and it is looking ugly.

2) we are trying to show indicator and values in the same column but which isn't working with the current logic which you have shared.

Request you to please look into the same and let us know if there is any way around.

Thanks a ton!

Re: Top 10 Viz tricks - Qonnections 2019

Patric_Nordstrom — Tue, 18 Jun 2019 09:14:35 GMT

1. Left align will make it look a bit better.

2. You could concatenate the value and the "light" (='⬤' & round(sum(Sales)) but then both would have the same color.

Thanks,

Patric

Re: Top 10 Viz tricks - Qonnections 2019

wenyan1206 — Thu, 20 Jun 2019 07:26:09 GMT

Thank you

Re: Top 10 Viz tricks - Qonnections 2019

qvwme_huthfa — Thu, 20 Jun 2019 14:59:08 GMT

Excellent. Approaching QlikView standard features, hopefully soon.

Re: Top 10 Viz tricks - Qonnections 2019

pavel_krejcik — Tue, 25 Jun 2019 08:39:16 GMT

Excellent tips, thanks!

Patric, can you also attach the GEO TABLES please to be able to do the reload?

Thx! Pavel.

Re: Top 10 Viz tricks - Qonnections 2019

Patric_Nordstrom — Tue, 25 Jun 2019 20:13:15 GMT

The __GEO_TABLE are normally loaded automatically, in Sense Desktop they are located here:

C:\Users\user\AppData\Local\Programs\Qlik\Sense\DataPrepService\src\geo

Server:

C:\Program Files\Qlik\Sense\DataPrepService\src\geo

Re: Top 10 Viz tricks - Qonnections 2019

pavel_krejcik — Thu, 11 Jul 2019 14:34:06 GMT

Thanks Patrick, I needed it exactly for QS Desktop.

Re: Top 10 Viz tricks - Qonnections 2019

LucaB-1991 — Tue, 22 Oct 2019 09:23:17 GMT

Excellent work!
Thank you

Re: Top 10 Viz tricks - Qonnections 2019

adamjank — Fri, 25 Oct 2019 09:10:13 GMT

Let's be honest - this the best thing related to the Qlik Sense for quite a long time
I wish that I've found it out few months earlier!

I look forward to the next examples!

Re: Top 10 Viz tricks - Qonnections 2019

dgreenberg — Fri, 01 Nov 2019 15:59:17 GMT

Really good stuff!

Re: Top 10 Viz tricks - Qonnections 2019

hppflpp — Mon, 06 Apr 2020 12:35:38 GMT

Hi Patric,

thank you so much for sharing this!

I have a question regarding the dynamic tables:

I'd like them to compare sales data from this year to sales data from last year, though.

I have a list of dimensions, including StatYear that contains the statistical year.

The following metric works:

Metrics:
Load * INLINE [
Metric, MetricNo, MetricFormula
Sales, 1, "num(Sum(Sales), '#.##0; -#.##0')"

I tried to include

Sales previous year, 2, "num(sum({$<StatYear={$(=max(StatYear)-1)}>}Sales), '#.##0; -#.##0')"

but it seems like the function that works perfectly fine for diagrams can't be used in the script. Do you have any advice?

Thanks in advance.

Re: Top 10 Viz tricks - Qonnections 2019

Patric_Nordstrom — Mon, 20 Apr 2020 09:57:17 GMT

@hppflpp

I would test the expression evaluates properly, first standalone, then with dollar expansion and then with firstsortedvalue to find out problem.

=$(='sum({<City={''Aachen''}>} Sales)')

Thanks,

Patric

Re: Top 10 Viz tricks - Qonnections 2019

Stefan_dT — Wed, 15 Jul 2020 14:16:25 GMT

I'm trying to convert the prev/next function from Stigchel, to work on an alphanumeric field (Site_Cd), but can't figure out how.

=subfield(Concat( {<OrderID={">$(=OrderID)"}>} DISTINCT OrderID,'@',OrderID),'@',1)

Needless to say, just swopping out Order_ID with Site_Cd doesn't work. I've got a feeling the issue is with the {">$(=Site_Cd)"}. Any suggestions?

Re: Top 10 Viz tricks - Qonnections 2019

Patric_Nordstrom — Wed, 15 Jul 2020 14:58:51 GMT

@Stefan_dT yes the dimension has to work with >.

Create a numeric version of Site_Cd with the sort you like, Site_Order. haven't tested but should work.

=subfield(Concat( {<Site_Order={">$(=Site_Order)"}>} DISTINCT Site_Cd,'@',Site_Order),'@',1)

Thanks,

Patric