QlikView Heat Map

[Anonymous]

Hi,

I have created a pivot table which has the following columns;

1. Product Line
2. OTS Target
3. Data Column's by Month

Each Product Line row has a target for measuring performance, which is the guiding factor for color coding for that specific row.

Example;

For Product Line - 6A, OTS Target is 9 days.

Now in that row cell data which is above 9 days need to be colored in 'Red' and cell data less than equal to 9 days need to be colored 'Green', while row cells which have no data should remain as is.

Regards,

Dev

[Anonymous]

Hi,

For each expression or dimension, you can just expand it and write an if statement for the background colour

[vikasmahajan]

go through this thread

Vikas