topic Re: Heatmap Pivot Table Qlikview in App Development

Heatmap Pivot Table Qlikview

oscar_olaya — Fri, 16 Feb 2024 14:30:22 GMT

Hello!
Is it possible to create a chart like this in Qlikview? Any Example?
Thanks!

Re: Heatmap Pivot Table Qlikview

woutermak — Fri, 16 Feb 2024 15:05:22 GMT

You can use the background color. If you have a range of 0 to 100%, you can use 10 colors to color your cel. Use Argb to use transparency. See in this case value 9. Same as 6 with more transparency.

Re: Heatmap Pivot Table Qlikview

stevedark — Mon, 19 Feb 2024 08:59:54 GMT

Hi @oscar_olaya

You want to use the cell background colour expression and the colourmix2 function. This requires three colours which are applied to +1, -1 and 0 respectively. You will need to put your expression in the function and ensure the values fall between 1 and -1. If you already have percentages between 0 and 1 you will need to double them and -1.

colormix2(((sum(Sales) / max(TOTAL Sales))*2)-1, rgb(220,0,0), rgb(0,220,0), rgb(200,90,0))

This image is from Sense, but it works the same in QlikView:

Load script to get dummy data for that is:

SalesData:
LOAD
num(RowNo(), '000000') as StoreNo,
floor(Rand()*100000) as Sales
AUTOGENERATE(20000);

Hope that helps.

Steve

Re: Heatmap Pivot Table Qlikview

oscar_olaya — Wed, 21 Feb 2024 18:18:26 GMT

@stevedark Excellent! Just right! Thank you!

Re: Heatmap Pivot Table Qlikview

oscar_olaya — Wed, 21 Feb 2024 18:19:41 GMT

@woutermak Thank you! I complemented it with the gradient