Skip to main content
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?