topic Re: How to create a Heat map in QlikView

How to create a Heat map

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am new to Qlikview we are replicating a tableau dashboard to Qlikview and we need a heat map exactly or somewhat similar to screenshot. Any help will be appreciated.

Thanks,

Nikita

Re: How to create a Heat map

vinieme12 — Tue, 04 Apr 2017 10:46:58 GMT

please post some sample data

Re: How to create a Heat map

Anil_Babu_Samineni — Tue, 04 Apr 2017 10:49:48 GMT

In Qlikview, we call straight object. Here, First one is simple attribute and then Image path with image Representative and then Metric which you showed in Qlikview. I am assuming, you want similar image

Re: How to create a Heat map

dhanaji_roman — Tue, 04 Apr 2017 11:23:03 GMT

Hi..I found this topic.. It shows how to create a heatmap using extension..

Open Source Geospatial Mapping Extension using KML files

Re: How to create a Heat map

Wed, 05 Apr 2017 05:27:41 GMT

Hi Vineeth,

PFB Dummy data ,

We want the bubble size to vary according to the actual column. It is not very prominent in the screenshot as the values are almost equal.

Skill	DUL_ATTR_KPI_ACTUAL
skill 1	0.002
skill 2	0.0318
skill 3	0.0324
skill 4	0.0379
skill 5	0.0379
skill 6	0.0381
skill 7	0.0424
skill 8	0.0456
skill 9	0.0456
skill 10	0.0481
skill 11	0.049
skill 12	0.0501
skill 13	0.0516
skill 14	0.0524
skill 15	0.0539
skill 16	0.0539
skill 17	0.0539
skill 18	0.0556
skill 19	0.0574
skill 20	0.0603
skill 21	0.0614
skill 22	0.0636
skill 23	0.0659
skill 24	0.0672
skill 25	0.0672
skill 26	0.0685
skill 27	0.0691
skill 28	0.0712
skill 29	0.0742
skill 30	0.0759
skill 31	0.0774
skill 32	0.0774

Re: How to create a Heat map

Wed, 05 Apr 2017 05:28:56 GMT

Hi Anil,

I don't want a image in between those all the bubbles whose size vary according to the actual values. Refer the data below.

Skill	DUL_ATTR_KPI_ACTUAL
skill 1	0.002
skill 2	0.0318
skill 3	0.0324
skill 4	0.0379
skill 5	0.0379
skill 6	0.0381
skill 7	0.0424
skill 8	0.0456
skill 9	0.0456
skill 10	0.0481
skill 11	0.049
skill 12	0.0501
skill 13	0.0516
skill 14	0.0524
skill 15	0.0539
skill 16	0.0539
skill 17	0.0539
skill 18	0.0556
skill 19	0.0574
skill 20	0.0603
skill 21	0.0614
skill 22	0.0636
skill 23	0.0659
skill 24	0.0672
skill 25	0.0672
skill 26	0.0685
skill 27	0.0691
skill 28	0.0712
skill 29	0.0742
skill 30	0.0759
skill 31	0.0774
skill 32	0.0774

Re: How to create a Heat map

Anil_Babu_Samineni — Wed, 05 Apr 2017 07:10:20 GMT

Does you mean, You want bubbles in between which based on Values. Then i would go for Mini Gauge settings and then call up ascending order. If thought, I will share QVW with you? Or else bit description required

Re: How to create a Heat map

Wed, 05 Apr 2017 07:15:29 GMT

Please share It will be helpful.I think we are on the same page now that it what I need.

Re: How to create a Heat map

vinieme12 — Wed, 05 Apr 2017 07:52:04 GMT

Unfortunately we don't have such capability in qlikview, but does the below help?

Re: How to create a Heat map

mato32188 — Wed, 05 Apr 2017 08:40:10 GMT

Hi Nikita,

sending you sample that could approach your solution in Tableau.

This is screenshot. Please find attached .qvw.

Martin

Re: How to create a Heat map

Anil_Babu_Samineni — Wed, 05 Apr 2017 09:34:01 GMT

FYI

Re: How to create a Heat map

Wed, 05 Apr 2017 09:36:59 GMT

Yes this is almost what I need. One addition I need the size of bubbles to vary according to the actual column.

Re: How to create a Heat map

Wed, 05 Apr 2017 09:38:14 GMT

Hi Martin,

Thanks a lot this is exactly what I wanted.

well one more thing can we should the % on the right hand side like in the screenshot I sent?

Re: How to create a Heat map

mato32188 — Wed, 05 Apr 2017 11:40:11 GMT

Hi Nikita,

there is possibility to center it, but I am not sure that it is sorted properly. Please check .qvw sample.

Re: How to create a Heat map

sarvesh — Wed, 05 Apr 2017 12:10:00 GMT

Please refer below mentioned link.. hope it helps .

Geographic Heat Map Visualization

Re: How to create a Heat map

Thu, 06 Apr 2017 03:29:47 GMT

Hi Martin,

I think you have attached the older file again this is what it shows.

Re: How to create a Heat map

mato32188 — Thu, 06 Apr 2017 13:02:30 GMT

here you go

Re: How to create a Heat map

Fri, 07 Apr 2017 05:12:58 GMT

Thanks a lot for the help