topic Re: Heat Map Extension issue in QlikView

Heat Map Extension issue

aniketsr — Mon, 10 Aug 2015 12:50:01 GMT

Hi Team,

I require a heat map extension objet which works similar to that of pivot table heat map.

Regards,

Aniket

Re: Heat Map Extension issue

aniketsr — Mon, 10 Aug 2015 12:51:11 GMT

any help on pivot chart heat map would also work

Re: Heat Map Extension issue

Anonymous — Tue, 11 Aug 2015 05:07:33 GMT

Hi Aniket,

Usually what I do with a heat make is:

1. Go to expressions

2. create your expresssion that you want to use with your heat map.

3. Once the expression is created, expand the expression and go to background colour.

4. In the Definition for the Background colour, try this formula:

=rgb((rank((set Analysis you want to use),1,1)

/max(TOTAL aggr(rank((set Analysis you want to use),1,1),<Group By Dimension>))*255),

255-(rank((set Analysis you want to use),1,1)

/max(TOTAL aggr(rank((set Analysis you want to use),1,1),<Group By Dimension>))*255),

Re: Heat Map Extension issue

MarcoWedel — Tue, 11 Aug 2015 05:50:07 GMT

Hi,

maybe this helps:

Sorted Heatmap example

regards

Marco

Re: Heat Map Extension issue

ecolomer — Tue, 11 Aug 2015 05:53:21 GMT

Similar that?

Re: Heat Map Extension issue

aniketsr — Tue, 11 Aug 2015 05:58:31 GMT

Hey Macro,

I have the similar requirement can you please send me the expression or suggest me an extension for the same.

Regards,

Aniket

Re: Heat Map Extension issue

aniketsr — Tue, 11 Aug 2015 06:07:26 GMT

Hey Thabang,

Thanks for the expression but iam getting only green colour in the chart .

Regards

Aniket.

Re: Heat Map Extension issue

Anonymous — Tue, 11 Aug 2015 06:11:32 GMT

Hi Aniket,

You might need to change the formula a bit depending on your requirements.

Re: Heat Map Extension issue

Kushal_Chawda — Tue, 11 Aug 2015 06:41:51 GMT

Hi,

You can do something like below

Go to your expression-> click on'+' and put below expression in your background colour

Expression:

=colormix1(sum(Amount) / $(=max(aggr(sum(Amount), YourDimension))), white(), Green())

You need to modify your expression as per the need

Re: Heat Map Extension issue

MarcoWedel — Tue, 11 Aug 2015 21:06:09 GMT

Hi,

hope this helps

regards

Marco