Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report

Top 10 Viz tips - Qonnections 2019 - Part I

100% helpful (3/3)
cancel
Showing results for 
Search instead for 
Did you mean: 
Patric_Nordstrom
Employee
Employee

Top 10 Viz tips - Qonnections 2019 - Part I

Last Update:

Jun 4, 2024 9:16:19 PM

Updated By:

Patric_Nordstrom

Created date:

May 14, 2019 8:01:03 PM

Attachments

top10w.png 

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:

Thanks,
Patric

Labels (2)
Comments
Patric_Nordstrom
Employee
Employee

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
Partner - Contributor
Partner - Contributor
Thanks Patrick, I needed it exactly for QS Desktop.
LucaB-1991
Contributor
Contributor

Excellent work!
Thank you

adamjank
Contributor III
Contributor III

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
Luminary Alumni
Luminary Alumni

Really good stuff!

hppflpp
Contributor II
Contributor II

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
Employee
Employee

@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
Contributor III
Contributor III

I'm trying to convert the prev/next function from

=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
Employee
Employee

@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
Partner - Contributor III
Partner - Contributor III

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

 

Version history
Last update:
‎2024-06-04 09:16 PM
Updated by: