Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How Can I paint a cell in a table by dimension ?
For example -
I What that each "Branch" Background will be painted in a different color... 1-blue, 2-green, etc...
There are more than 4 branches, so there are another options except using a long "if" or "match" ?
Thanks
Branch | Sales |
---|---|
1 | 1500 |
2 | 2000 |
3 | 3000 |
4 | 4000 |
You can assign colors in the script itself
Assign Colors in QlikView Script – Let’s Do Something Cool with Color
Here is another one
http://www.qlikfix.com/2010/12/17/consistent-dimension-colors/
Here is an example
Load script
Table:
LOAD Branch,
Sales
FROM
[https://community.qlik.com/thread/288555]
(html, codepage is 1252, embedded labels, table is @1);
Color:
LOAD * INLINE [
Branch, R, G, B
1, 0, 0, 255
2, 0, 255, 0
3, 255, 0, 0
4, 200, 100, 0
];
Thank you !
Very helpful