Static Map Image with Background Color

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

Hello,

I have the following mall map:

Then I have something like:

STORE_ID	STORE	SALES	PERIOD
G04	POLO	50000	07/2017
G04	POLO	70000	08/2017
G05	BURBERRY	80000	07/2017
G05	BURBERRY	38000	08/2017
G08	MANDARIN	15000	07/2017
G09	SWEET	20000	07/2017

I want to know if there's any way to associate each STORE_ID from the table to the corresponding map, in order to show each STORE on the map where the background color would be GREEN or RED depending on SALES.

Do you know if that would be possible?

Thanks!!!

Re: Static Map Image with Background Color

Anil_Babu_Samineni — Fri, 11 May 2018 01:59:26 GMT

can you try this?

If(STORE_ID = P({<STORE_ID = {"=STORE_ID = P(SALES)"}>} STORE_ID), Green(), Red())

topic Static Map Image with Background Color in QlikView

Static Map Image with Background Color

Re: Static Map Image with Background Color