topic Re: Heat map in Qlikview in QlikView

Heat map in Qlikview

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi, I did a floor plan heat map dashboard using Excel something like below which the shapes contain conditional formatting. Is there any possible way to create it in Qlikview or link it into Qlikview?

Re: Heat map in Qlikview

Anil_Babu_Samineni — Sun, 10 Dec 2017 08:14:00 GMT

When you talk about "Conditional Formatting" - Does this dynamic depends on Filter from Drop down? Will you give better clear on this?

Re: Heat map in Qlikview

Anonymous — Mon, 11 Dec 2017 06:55:07 GMT

Yes. The size and color of the shapes depend on filter from drop down, and the range is the percentile of the data (drop down list from KPI). For example, if A falls between percentile 0 and 10, it will be size 1 and color code depends on the drop down.

Percentile	Size	Color code
0	1	rgb
10	2	rgb
20	3	rgb
30	4	rgb
40	5	rgb
50	6	rgb
60	7	rgb
70	8	rgb
80	9	rgb
90	10	rgb

Now i can only think of is conditional formatting a text box. Not sure if I'm able to change the size, but let's start with color. Does macro in Qlikview can work as Excel?

Re: Heat map in Qlikview

Anil_Babu_Samineni — Mon, 11 Dec 2017 11:58:07 GMT

May be read this? Colours | Qlik Community

PFA

Re: Heat map in Qlikview

Anil_Babu_Samineni — Fri, 15 Dec 2017 02:31:40 GMT

Have you got your issue? If so, Please close this thread

Re: Heat map in Qlikview

Anonymous — Fri, 15 Dec 2017 04:38:06 GMT

Not really what I need, but I found a way to do it.

Thanks for your reply anyway

Re: Heat map in Qlikview

Anil_Babu_Samineni — Fri, 15 Dec 2017 04:58:15 GMT

That is okay, but you have to close this thread by flag correct answer. So, you have to post what you have done with this issue and mark your response as correct and others helpful. Then next land users can understand on there environment..

Thanks

Re: Heat map in Qlikview

Anonymous — Sat, 16 Dec 2017 03:52:46 GMT

Alright. So I've figured out how to do the heat map for floor plan by other way.

For KPI, I used the button to set variables to vKPI, which I get the idea from the link below.

https://www.quickintelligence.co.uk/qlikview-buttons/

And for the shapes, I replaced them using text boxes, and conditional formatting the background color.

Hope that helps.