topic Re: Conditional Background Color in QlikView

Conditional Background Color

Anonymous — Fri, 27 Mar 2015 21:50:10 GMT

Hello,

I have this expression in the background color of my Sales Order dimension:

=if(aggr(count([Prod. Order]), [Sales Order #])>=2,YELLOW())

It seems to only turn the sales order row yellow when there are two production orders (also in my dimensions) for that sales order. I was hoping that the above logic would highlight the sales orders that have more than two production orders as well. But, this is what I'm getting:

Can someone please advise on how to get this to work in the cases that there are 3 or more production orders per sales order?

Thanks a ton,

Ron

Re: Conditional Background Color

Fri, 27 Mar 2015 23:08:02 GMT

Hi,

try

=If(Count(total<[Sales Order #]> [Prod. Order]) >=2,Yellow())

Re: Conditional Background Color

Sat, 28 Mar 2015 05:19:37 GMT

Hi Ron

Please check this example file

Which is attached in the thread.

Re: Conditional Background Color

Anonymous — Sat, 28 Mar 2015 14:12:15 GMT

Thank you both for your responses. Andrei's answer worked best for my case, but there are some great examples found in the above .qvw file. There are some cases where there is a production order firming (still a planned order, this is SAP) and the 2nd oncoming production order is currently displaying as null (can't count a null). You can see an example of this in my screenshot. The Sales Order cells won't highlight in this case. That's OK though. The requirement should be satisfied.

Thanks again,

Ron