Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
adimiz123
New Contributor III

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

Re: Color By Dimension inside table

Re: Color By Dimension inside table

Re: Color By Dimension inside table

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
New Contributor III

Re: Color By Dimension inside table

Thank you !

Very helpful

Community Browser