Qlik Community

Ask a Question

Documents

Qlik Sense documentation and resources.

Announcements
Live Chat, June 29th 10AM ET. Bring your Qik Sense Enterprise, Client Managed questions! REGISTER

Top 10 Viz tips - Qonnections 2019 - Part I

Patric_Nordstrom
Employee
Employee

Top 10 Viz tips - Qonnections 2019 - Part I

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

Similar but for Qlik GeoAnalytics :

Thanks,
Patric

Labels (2)
Attachments
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
Partner
Thanks Patrick, I needed it exactly for QS Desktop.
0 Likes
LucaB-1991
Contributor
Contributor

Excellent work!
Thank you

0 Likes
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!

0 Likes
dgreenberg
Luminary Alumni
Luminary Alumni

Really good stuff!

0 Likes
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.

0 Likes
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

0 Likes
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?

0 Likes
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
Partner

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

 

0 Likes
Version history
Revision #:
15 of 15
Last update:
‎2021-04-13 04:28 AM
Updated by:
 
Contributors