Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Color gradient bar for heat map (pivot table)

I have a pivot table made as a heat map with colours changing from light to dark with increasing values of the expression. I would like to show a color gradient bar at the bottom of the chart so that the user has an idea of what colour represents what range of values.

How can I go about it?

Thanks.

3 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

How about using a similar Pivot table with no Dimensions, and the definitions of the colors displayed over the same color backgrounds? Or a collection of Text Objects doing the same?

Cheers,

Oleg Troyansky

Upgrade your Qlik skills at the Masters Summit for Qlik - coming soon to Milan, Italy!

MarcoWedel

Hi,

one solution could be:

QlikCommunity_Thread_204351_Pic1.JPG

QlikCommunity_Thread_204351_Pic2.JPG

QlikCommunity_Thread_204351_Pic3.JPG

QlikCommunity_Thread_204351_Pic4.JPG

In your real application you could replace Max(Value) with something like Max(Aggr(yourexpression, yourdimension1, yourdimension2))

hope this helps

regards

Marco

Anonymous
Not applicable
Author

I am trying to do the same thing in Qlik Sense and your example file wouldn't open in it. Could you please share your values in the variable vColorBarStep?