Top 10 Viz tips - Qonnections 2019 - Part I

[Patric_Nordstrom]

 

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 invented 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 tips in the same style:

• Sense Visualization tips part VI
• Sense Visualization tips 2021 part V QlikWorld
• Sense Visualization tips 2020 part IV
• Sense Visualization tips 2020 Part III Qlik World
• Sense Visualization tips 2019 Part II

Similar but for Qlik GeoAnalytics :

• Qlik GeoAnalytics tips 2020 QlikWorld
• Qlik GeoAnalytics tips 2019 Qonnections
• Qlik GeoAnalytics tips 2018 Qonnections

Thanks,
Patric

[Patric_Nordstrom]

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

[pavel_krejcik]

Thanks Patrick, I needed it exactly for QS Desktop.

[LucaB-1991]

Excellent work!
Thank you

[adamjank]

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!

[dgreenberg]

Really good stuff!

[hppflpp]

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.

[Patric_Nordstrom]

@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

[Stefan_dT]

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?

[Patric_Nordstrom]

@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

[jjdench]

Hi Patric,

Some good idea's here! I'm trying to replicate the Map image background in our Qlik Sense SAAS environment but its not showing the image, will the url be blocked in SAAS? and is there a way in SAAS of opening it up to certain URL's that contain image's as in this example?

Thanks

Justin