Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
microwin88x
Contributor III

Static Map Image with Background Color

Hello,

I have the following mall map:

Capture.JPG.jpg

Then I have something like:

STORE_IDSTORESALESPERIOD
G04POLO5000007/2017
G04POLO7000008/2017
G05BURBERRY8000007/2017
G05BURBERRY3800008/2017
G08MANDARIN1500007/2017
G09SWEET2000007/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!!!

1 Reply
Highlighted

Re: Static Map Image with Background Color

can you try this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)