Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
How to get color for irregular intervals of sales using interval Match ?
Below is my Data Patter and Ranges
I have to Show sales value in Text Object .
Thanks & Regards
Shekar
Hi Shekar,
I read what you say but your stated requirement was to be shown how to associate values from a list of colour names to a Region based on a sales value and you've been shown that. The list of colours you gave included some that are not standard QlikView colours, Orange for example. If they were all standard colours or RGB references then all you would need to do would be define your text colour as =Colour.
May I suggest you redefine your colours from this list or decide for yourself which RGB shades best meet your requirements.
Black()
Darkgray()
Lightgray()
White()
Blue()
Lightblue()
Green()
Lightgreen()
Cyan()
Lightcyan()
Red()
Lightred()
Magenta()
Lightmagenta()
Brown()
Yellow()
Kind regards
Andrew
Hi Andrew ,
The color i mentioned were merely for reference , the basic idea was to get colors based on sales value falling between ranges , that too using Interval Match .
Thanks & Regards
Shekar
It should be marked resolved now. Because as per the thread I think you are done now.