topic Re: Heat Maps in QlikView

Heat Maps

danielnevitt — Tue, 12 Feb 2013 09:59:24 GMT

Hi,

I have read some posts regarding the ability to use heat maps in Qlikview.

Is this complicated to set up? I have the attached qvw data file and I would really appreciate if someone could provide some help with regards to getting started with setting up a heat map.

Ideally I would like to show the following:

Percentage of Trading Heat Map Colour

50%+ Red

20%-49% Orange

10%-19% Yellow

5%-9% Light Green

0%-4% Green

Any help will be really appreciated. Please let me know if you require any further information.

Regards,

Daniel

Re: Heat Maps

brenner_martina — Tue, 12 Feb 2013 10:17:29 GMT

Hi Daniel,

in a Listbox it is not possible, but in a chart. Click on the PLUS-sign, there you have possibility to enter an if-then-else condition for background or text color. Look at the attached file!

greetings from Munich

Martina

Re: Heat Maps

danielnevitt — Tue, 12 Feb 2013 10:24:39 GMT

Hi Martina,

Thank you so much for you reply. The table you provided has helped with increasing my knowledge of this subject.

Is it possible to link the data to an actual map of the world? This would provide an excellent reporting visual.

Regards,

Daniel

Re: Heat Maps

brenner_martina — Tue, 12 Feb 2013 10:27:05 GMT

Hi Daniel,

yes, but only with third party software like google maps, open streetview, geoqlik or globeqlik and others.

Greetings from Munich

Martina

Re: Heat Maps

danielnevitt — Tue, 12 Feb 2013 10:30:04 GMT

Hi Martina,

Is it difficult to set up using google maps?

Do you have any information with regards to how I would start the set up process?

Regards,

Daniel

Re: Heat Maps

brenner_martina — Tue, 12 Feb 2013 10:38:33 GMT

Hi Daniel,

yes and no, you can get any information about it from the goggle homepage.

Greetings from Munich

Martina

Re: Heat Maps

danielnevitt — Tue, 12 Feb 2013 10:56:22 GMT

Thanks Martina.

I've read google and it seems quite technical (for a non IT person like myself). If anyone has a working example of how to set up a heat map with a google map, I might be able to replicate the process.

Again any help with this, will be much appreciated.

Regards,

Daniel

Re: Heat Maps

brenner_martina — Tue, 12 Feb 2013 11:13:42 GMT

Hi Daniel,

this is a question of sales, google give this information not gratis! You have to get a licence key! And the exprressions are very complicated!

Greetings from Munich

Martina