Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

chamarthiprathy
New Contributor III

How to write expression for Back ground color in Pivot table

We have taken below data in Pivot table and wanted to give three back ground colors based on the Top and bottom columns for each row.Suppose if taken one row as example, Value between 82.4 and 80.4 ( i.e 82 ) should be displayed as yellow background, value greater than 82.4 and 80.4 (i.e  82.7) should have green back ground , values less than 82.4 and 80.4 (i.e 76.4,80.2,76.5,77.5,78.9 and 78.4) should have red back ground

Could you please suggest how to write an expression for back ground color to appear as above

Section12345678TopBottom
A76.482.78280.276.577.578.978.482.480.4
B7886.687.882.379.381.881.880.684.382.3
C69.367.372.460.56563.663.660.67068

Thanks
Rajesh

1 Reply

Re: How to write expression for Back ground color in Pivot table

Hi,

Are you using QlikView or Qlik Sense?

In QlikView you have a tab called "Visual Cues" which will help you to define the upper and lower range and then colors for the same.

For Qlik Sense you will have to write the expression with if else condition.

Regards,

Kaushik Solanki

Community Browser