Discussion Board for collaboration on QlikView Layout & Visualizations.
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?
Go to Solution.
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),
Thanks a lot! I only have a limited amount of segments and it works perfectly.
thanks for your help.
no problem, glad it helped
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