Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW

Top 10 Viz tips - Qonnections 2019 - Part I

100% helpful (3/3)
cancel
Showing results for 
Search instead for 
Did you mean: 
Patric_Nordstrom
Employee
Employee

Top 10 Viz tips - Qonnections 2019 - Part I

Last Update:

Jun 4, 2024 9:16:19 PM

Updated By:

Patric_Nordstrom

Created date:

May 14, 2019 8:01:03 PM

Attachments

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

Thanks,
Patric

Labels (2)
Comments
paulcalvet
Partner - Specialist
Partner - Specialist

Excellent !

This application is a must have 😀

Paul

luiskeyrus
Partner - Contributor III
Partner - Contributor III

Thanks!

lironbaram
Partner - Master III
Partner - Master III

HI Patric

great app , 

thanks for sharing 

melisa_tesillo
Partner - Contributor II
Partner - Contributor II

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!

 

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

qvwme_huthfa
Contributor
Contributor

Excellent. Approaching QlikView standard features, hopefully soon.

pavel_krejcik
Partner - Contributor
Partner - Contributor

Excellent tips, thanks!

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

Thx! Pavel.

Version history
Last update:
‎2024-06-04 09:16 PM
Updated by: