Qlik Community

Ask a Question

Documents

Qlik Sense documentation and resources.

Announcements
Qlik Insider - Maximize your investment, Join this webinar, May 26th. Register Today

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

Excellent !

This application is a must have 😀

Paul

luiskeyrus
Partner
Partner

Thanks!

lironbaram
Partner
Partner

HI Patric

great app , 

thanks for sharing 

melisa_tesillo
Partner
Partner

Thanks for sharing Patric!!

yossefsalomao
Contributor
Contributor

Thank you 

deepika_gohil
Contributor
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
Patric_Nordstrom
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

wenyan1206
Luminary Alumni
Luminary Alumni

Thank you

0 Likes
qvwme_huthfa
Contributor
Contributor

Excellent. Approaching QlikView standard features, hopefully soon.

0 Likes
pavel_krejcik
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 #:
15 of 15
Last update:
a month ago
Updated by:
 
Contributors