topic Re: Color gradient bar for heat map (pivot table) in QlikView

Color gradient bar for heat map (pivot table)

Thu, 04 Feb 2016 21:44:24 GMT

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.

Re: Color gradient bar for heat map (pivot table)

Oleg_Troyansky — Thu, 04 Feb 2016 22:12:24 GMT

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!

Re: Color gradient bar for heat map (pivot table)

MarcoWedel — Thu, 04 Feb 2016 22:41:01 GMT

Hi,

one solution could be:

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

hope this helps

regards

Marco

Re: Color gradient bar for heat map (pivot table)

Anonymous — Tue, 27 Feb 2018 20:12:49 GMT

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?