topic Re: Color By Dimension inside table in QlikView

Color By Dimension inside table

Xabinav — Sun, 21 Jan 2018 16:46:40 GMT

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

sunny_talwar — Sun, 21 Jan 2018 17:06:48 GMT

You can assign colors in the script itself

sunny_talwar — Sun, 21 Jan 2018 17:08:21 GMT

Here is another one

sunny_talwar — Sun, 21 Jan 2018 17:51:39 GMT

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

];

Xabinav — Mon, 22 Jan 2018 00:56:08 GMT

Thank you !

Very helpful