topic Conditional Background color in Expression in QlikView

Conditional Background color in Expression

schivet — Mon, 23 Nov 2015 12:53:46 GMT

Hi,

This sounds like a simple problem but I can't manage it .

I would like to get this directly in my object:

I need to have a different background color when the amount is different to the other ones, knowing that the sum for Source 1 can be only the sum of one row when Source 2 can be a sum of several rows:

Name	Curr	Source	Amount
Article 1	EUR	Source 2	850
Article 1	EUR	Source 2	-850
Article 1	EUR	Source 4	-850
Article 1	EUR	Source 1	1 592
Article 1	EUR	Source 2	1 592
Article 1	EUR	Source 3	1 592
Article 1	EUR	Source 4	1 592

Re: Conditional Background color in Expression

swuehl — Mon, 23 Nov 2015 17:13:39 GMT

Maybe try a background color expression like

=If(Sum(Amount) <> Only({<Source = {'Source 1'}>} TOTAL<Name, Curr> Amount), LightRed())

Re: Conditional Background color in Expression

schivet — Tue, 24 Nov 2015 07:38:58 GMT

Hi Swuehl!

Thank you! That's a really good start but won't work all the time because Source 1 is not alway the reference... I have added an example here when Source 1 is not the correct value and should be the one in color and not the others:

Any idea?

Thanks for your help

Re: Conditional Background color in Expression

swuehl — Tue, 24 Nov 2015 10:53:33 GMT

Try a background color expression like

=If(Sum(Amount) <> Mode(TOTAL<Name,Curr> Aggr( sum(Amount),Name,Curr,Source)), LightRed())

Re: Conditional Background color in Expression

effinty2112 — Tue, 24 Nov 2015 11:07:20 GMT

Hi Stephane,

Try this as your colour expression:

=If(Sum(Amount)<>Mode(TOTAL <Name> Aggr(Sum(Amount),Name, Source)), LightRed())

Name	Source	Source 1	Source 2	Source 3	Source 4
Article 1		1592	1592	1592	742
Article 2		800	1592	1592	1592

This colours the cell if the value differs from the most common value for that Article.

Cheers