topic Re: How can we get multiple colour heat map with input box values (esp in Pivot tables) in QlikView

How can we get multiple colour heat map with input box values (esp in Pivot tables)

Tue, 26 Aug 2014 09:07:43 GMT

Hi all,

Can you please help me to create Pivot table (Heat Map) with input box values.

Check below Pivot table:

Pivot table
	Year	2009
	Month	Jan	Feb	Mar	Apr
a		20%	40%	80%	75%
b		30%	30%	50%	50%
c		40%	20%	75%	80%

Input Box:

Input Box
vGreen	=	0.8
vBlue	=	0.5
vRed	=	0

vGreen should be >=0.8
vBlue should be >=0.5 <0.8
vRed should <0.5

Question: I've created three variables (vGreen, vBlue and vRed) and assigned them to input box to change the numbers manually. How can I change colours in Pivot table if numbers entered manually in Input Box.

Thanks for your help.

Re: How can we get multiple colour heat map with input box values (esp in Pivot tables)

Tue, 26 Aug 2014 09:27:50 GMT

Hi,

Can you attach your sample app.

Satish.

Re: How can we get multiple colour heat map with input box values (esp in Pivot tables)

MarcoWedel — Tue, 26 Aug 2014 10:33:48 GMT

Hi,

maybe like this?:

hope this helps

regards

Marco

Re: How can we get multiple colour heat map with input box values (esp in Pivot tables)

Tue, 26 Aug 2014 10:39:15 GMT

Thanks Marco. Will check, hope this works......

Regards,

Srinivasu

Re: How can we get multiple colour heat map with input box values (esp in Pivot tables)

ThornOfCrowns — Tue, 26 Aug 2014 10:50:22 GMT

There is a great tutorial about Pivot Table heatmaps at qlikfreakDOTwordpressDOTcom/2014/03/09/heat-map/#more-29

Change DOT to . to get the URL!