topic Re: HeatMap implementation in Qlikview pivot table in QlikView

HeatMap implementation in Qlikview pivot table

Anonymous — Wed, 11 Jul 2018 09:52:19 GMT

Hi,

I am trying to implement Heatmap in QlikView Pivot table using colormix wizard, but am unable to get the expected output like the below attachment ( which is done in Excel).

If anyone has worked on similar chart can you please help me out here ?

Thanks,

Ranjitha

Re: HeatMap implementation in Qlikview pivot table

tresB — Wed, 11 Jul 2018 10:03:47 GMT

Have a look here for idea:

How to show or visualize this kind of data?

Heat Map

Re: HeatMap implementation in Qlikview pivot table

Anonymous — Thu, 12 Jul 2018 05:46:42 GMT

I have made use of below expression for getting the upper limit and lower limit colors in the colormix wizard, which works for me and am getting gradient of colors row wise in my pivot table.

RangeMax (First(total <ValueExpression>,1,NoOfRows(total)))
RangeMin (First(total <ValueExpression>,1,NoOfRows(total)))

-> Similarly I want to find out the Median of the expression and give a color in the intermediate value. which am not able to achieve.

Can you help me out here ?

Thank you!

Re: HeatMap implementation in Qlikview pivot table

ziaulhaque — Tue, 07 May 2019 11:17:17 GMT

Hi Ranjit,
Hope you have visualized the required. I am looking for solution for similar kind of representation. Kindly help me with sample code.

Thanks

Re: HeatMap implementation in Qlikview pivot table

FabioP — Mon, 25 Nov 2019 19:02:02 GMT

Hello Ranjit,

- First of all, to prepare your Table, see the solution of thread bellow:
https://community.qlik.com/t5/New-to-QlikView/How-to-crosstab-in-QlikView/m-p/1648040#M383585

- Now, to have you Heatmap, use the script bellow in background of the expression you need to personalize:
ColorMix2 (if(YOUR_FIELD<Median(TOTAL YOUR_FIELD),-Sqrt(-(YOUR_FIELD-Median(TOTAL YOUR_FIELD))/(Median(TOTAL YOUR_FIELD)-Min(TOTAL YOUR_FIELD))),Sqrt((YOUR_FIELD-Median(TOTAL YOUR_FIELD))/(Max(TOTAL YOUR_FIELD)-Median(TOTAL YOUR_FIELD)))), ARGB(255, 0, 255, 0), ARGB(255, 255, 0, 0), ARGB(255, 255, 255, 0))

- Change YOUR_FIELD for you column.