

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Top 10 Viz tips - Qonnections 2019 - Part I
Jun 4, 2024 9:16:19 PM
May 14, 2019 8:01:03 PM
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 II, Season I
- Top 10 Tips Part 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


- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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

- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content

- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Excellent work!
Thank you

- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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!
.png)
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Really good stuff!

- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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.


- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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

- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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?


- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
@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

- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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