Discussion board where members can get started with QlikView.
I have created a pivot table which has the following columns;
Each Product Line row has a target for measuring performance, which is the guiding factor for color coding for that specific row.
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.
For each expression or dimension, you can just expand it and write an if statement for the background colour
go through this thread