topic Re: Background Color in QlikView

Background Color

bkn — Fri, 30 May 2014 22:10:54 GMT

I have a Listbox with values Q1,Q2,Q3,Q4.. My requirement is : When I select Q1 and Q2 together , then my pivot table background will be changed base on numbers and when i select Q1 and Q2 and Q3, the background color change in Pivot Table.

How can i write expression to have the multiple value selected in ListBox ?

Thanks in Advance.

Re: Background Color

maxgro — Fri, 30 May 2014 22:38:23 GMT

if your listbox is on field1 and you want to check if Q1 and Q2 are selected (green) or possible (white)

=if(concat(distinct field1, '', field1)='Q1Q2', 1, 0)

Re: Background Color

bkn — Fri, 30 May 2014 22:45:47 GMT

IF(FiscalQuarter='Q4' AND FiscalQuarter='Q4',

if([Sold]/[Target]>=0.138, LightGreen(),

if([Sold]/[Target]>=0.111, Yellow(),

if([Sold]/[Target]=0,lightRed(),lightRed())))

Can you guide me how to change this expression on your format. Please.

Re: Background Color

bkn — Fri, 30 May 2014 22:51:29 GMT

IF(FiscalQuarter='Q1' AND FiscalQuarter='Q2',

if([Sold]/[Target]>=0.138, LightGreen(),

if([Sold]/[Target]>=0.111, Yellow(),

if([Sold]/[Target]=0,lightRed(),lightRed())))

Can you guide me how to change this expression on your format. Please.

Re: Background Color

Anonymous — Sat, 31 May 2014 00:33:18 GMT

Hello.

Using Massimo's idea, your expression would be like this:

if(Concat(Distinct FiscalQuarter, '', FiscalQuarter) = 'Q1Q2',

if([Sold]/[Target]>=0.138, LightGreen(),

if([Sold]/[Target]>=0.111, Yellow(),

if([Sold]/[Target]=0,lightRed(),lightRed())))

Hope it helps.

Re: Background Color

its_anandrjs — Sat, 31 May 2014 07:12:13 GMT

Another way of doing this with Getfieldselections

=if(Replace(GetFieldSelections(FiscalQuarter), ',','') = 'Q1 Q2',

if([Sold]/[Target]>=0.138, LightGreen(),

if([Sold]/[Target]>=0.111, Yellow(),

if([Sold]/[Target]=0,lightRed(),lightRed() ) ) ) )

Re: Background Color

bkn — Mon, 02 Jun 2014 16:27:30 GMT

Thanks, it works ...