Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
It would be best to transform your data using The Crosstable Load
Have you see this already?
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
It would be best to transform your data using The Crosstable Load
Thanks Sunny,
That worked perfectly!