topic how to use the same colours in QlikView

how to use the same colours

Thu, 10 Oct 2013 13:24:09 GMT

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

Re: how to use the same colours

rustyfishbones — Thu, 10 Oct 2013 13:35:01 GMT

How many segments do you have?

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

Add it here

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

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

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

RED())))

Re: how to use the same colours

Thu, 10 Oct 2013 13:42:11 GMT

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

thanks for your help.

perry

Re: how to use the same colours

rustyfishbones — Thu, 10 Oct 2013 13:47:36 GMT

no problem, glad it helped

Re: how to use the same colours

Tue, 15 Oct 2013 04:38:06 GMT

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