Best solution for Heatmap

[felipe_oliveira]

Hi Masters

I was wondering if it is possible to build heatmap in Qlikview using pivot table. Actually, if there is any other better way to do it I am fine with it.

my data base looks like this:

Application_id	Year	Mont	P001	P002	P003	P004	P005	P006	P007	P...
00001	2017	Jan	Refer	NULL	Refer	Accept	Accept	Refer	Accept	...
00002	2017	Jan	Refer	Accept	Accept	Accept	Accept	Accept	Accept	...
00003	2017	Feb	Accept	Refer	Accept	Refer	NULL	Refer	Refer	...
00004	2017	Feb	Refer	Accept	Refer	Accept	Refer	Accept	Refer	...
00005	2017	Mar	Refer	Refer	Accept	NULL	Refer	Accept	Accept	...
00006	2017	Apr	NULL	Accept	Refer	Refer	NULL	Refer	NULL	...
00007	2017	Apr	Refer	Refer	Refer	Accept	Accept	Refer	Accept	...
00008	2017	Apr	Refer	Accept	Accept	Refer	Accept	Accept	Accept	...
....		...	...	...	...	...	...	...	...	...

I would like the heatmap to look like the attached file based on the count of "Refer" status

Please advise

Thanks!

Felipe

[sunny_talwar]

Have you see this already?

Heat Map – Qlik Freak

[felipe_oliveira]

Yes I have, but the problem in my case is that I have a lot of different columns with the data (P001, P002 etc). Most of the solutions I have seen pull the data from one single column

[sunny_talwar · Accepted solution]

It would be best to transform your data using The Crosstable Load

[felipe_oliveira]

Thanks Sunny,

That worked perfectly!