Qlik Community

Qlik Sense Enterprise Documents & Videos

Documents & videos about Qlik Sense.

Top 10 Viz tricks - Qonnections 2019

Employee
Employee

Top 10 Viz tricks - Qonnections 2019

top10w.png 

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

Here's a link to a similar session about Qlik GeoAnalytics:

https://community.qlik.com/t5/Qlik-GeoAnalytics-Documents/Top-10-QGA-tricks-Qonnections-2019/ta-p/15...

Attachments
Comments
Partner
Partner

Excellent !

This application is a must have 😀

Paul

Partner
Partner

Thanks!

Partner
Partner

HI Patric

great app , 

thanks for sharing 

Partner
Partner

Thanks for sharing Patric!!

yossefsalomao
New Contributor

Thank you 

deepika_gohil
New Contributor

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!

 

0 Likes
Employee
Employee

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

0 Likes
Luminary
Luminary

Thank you

0 Likes
qvwme_huthfa
New Contributor

Excellent. Approaching QlikView standard features, hopefully soon.

0 Likes
Partner
Partner

Excellent tips, thanks!

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

Thx! Pavel.

0 Likes
Version history
Revision #:
6 of 6
Last update:
‎2019-05-24 11:23 AM
Updated by:
 
Contributors