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

[paulcalvet]

Excellent !

This application is a must have 😀

Paul

[luiskeyrus]

Thanks!

[lironbaram]

HI Patric

great app , 

thanks for sharing 

[melisa_tesillo]

Thanks for sharing Patric!!

[yossefsalomao]

Thank you 

[deepika_gohil]

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!

[Patric_Nordstrom]

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

[wenyan1206]

Thank you

[qvwme_huthfa]

Excellent. Approaching QlikView standard features, hopefully soon.

[pavel_krejcik]

Excellent tips, thanks!

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

Thx! Pavel.