Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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