topic Generating background colours for codes on a straight table in QlikView

Generating background colours for codes on a straight table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi

How do I generate a Background colour for rows on a straight table that were used as a dimension.

Eg.

if(LeaveCode='AA',Green(),

if(LeaveCode='DA',Red(),

if(LeaveCode='PA',Yellow(),

if(LeaveCode='AS',Green(),

if(LeaveCode='DS',Red(),

if(LeaveCode='PS',Yellow(),

if(LeaveCode='PH',Blue()

Re: Generating background colours for codes on a straight table

m_woolf — Mon, 21 May 2018 11:53:07 GMT

if(LeaveCode='AA',Green(),

if(LeaveCode='DA',Red(),

if(LeaveCode='PA',Yellow(),

if(LeaveCode='AS',Green(),

if(LeaveCode='DS',Red(),

if(LeaveCode='PS',Yellow(),

if(LeaveCode='PH',Blue())))))))

Re: Generating background colours for codes on a straight table

Anonymous — Mon, 21 May 2018 11:56:08 GMT

Hi,

Go to the dimension, expand that to find the Background color expression and paste the following:

if(LeaveCode='AA',Green(),

if(LeaveCode='DA',Red(),

if(LeaveCode='PA',Yellow(),

if(LeaveCode='AS',Green(),

if(LeaveCode='DS',Red(),

if(LeaveCode='PS',Yellow(),

if(LeaveCode='PH',Blue())))))))