NEED HELP

[gireesh1216]

HI Friends,

I hava data like below table.

if id has "RED" status.overal status always RED.

if all GREEN then overal status GREEN

How do this in pivot table?

How to do this in front end in qlikview?

[shiveshsingh]

try this as expression

aggr(if( Prov='GREEN' and Comp='GREEN' and Reco='GREEN','GREEN','RED'),ID,Application,Layer)

[gireesh1216]

hello shiveshsingh

Not working above expression.

[Qrishna]

Somehting like this?

[gireesh1216]

Yes..How to do that...

On Wed, 25 Apr 2018, 11:29 pm Krishna Nagulapally, <qcwebmaster@qlikview.com>

[Qrishna]

PSA

[sasiparupudi1]

My be try

If(SubstringCount( aggr(Max(Prov)&','&Max(Comp)&','&Max(Reco),ID,Application,Layer),'RED')>0,'RED','GREEN')

[puneetagarwal]

Hi Gireeesh ,

Probably you can try this expression as well.

=if( Application='B' or Prov='Red'or Comp='Red' or Reco='Red','Red','Green');

Regards,

Puneet Agarwal

[gireesh1216]

Working fine. But I am looking front end calculation in qlikview.