Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
adimiz123
Creator
Creator

Color By Dimension inside table

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

BranchSales
11500
22000
33000
44000

a.PNG

4 Replies
sunny_talwar

sunny_talwar

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

];

Capture.PNG

adimiz123
Creator
Creator
Author

Thank you !

Very helpful