Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

how to use the same colours

I have a list of clients, their location (X,Y coordinate) and their market segment. I have plotted these clients over a map in a scatter plot diagram. So far so good.

Now I want to assign a specific colour to a market segment, so if I select the market segment view I see the same clients, but then coloured according the market.

I have really no Idea how to solve it. an example of my issue is in the appendix.

Who can give me the clue?

regards

perry

1 Solution

Accepted Solutions
rustyfishbones
Honored Contributor II

Re: how to use the same colours

How many segments do you have?

If it's not too many you could create an IF statement

Add it here

2013-10-10_1424.png

IF(MarketSeg = 1, RGB(0,255,0),

     IF(MarketSeg = 2, RGB(255,200,200),

          IF(MarketSeg = 3, RGB(0,100,50),

          RED())))

4 Replies
rustyfishbones
Honored Contributor II

Re: how to use the same colours

How many segments do you have?

If it's not too many you could create an IF statement

Add it here

2013-10-10_1424.png

IF(MarketSeg = 1, RGB(0,255,0),

     IF(MarketSeg = 2, RGB(255,200,200),

          IF(MarketSeg = 3, RGB(0,100,50),

          RED())))

Not applicable

Re: how to use the same colours

Thanks a lot! I only have a limited amount of segments and it works perfectly.

thanks for your help.

perry

rustyfishbones
Honored Contributor II

Re: how to use the same colours

no problem, glad it helped

Not applicable

Re: how to use the same colours

Yeah the IF condition was the best and easy way for it. I too had tried it and it was successful for me too.

water damage pompano beach

Community Browser