topic Re: NEED HELP in QlikView

NEED HELP

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

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 — Wed, 25 Apr 2018 16:55:53 GMT

try this as expression

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

gireesh1216 — Wed, 25 Apr 2018 17:23:22 GMT

Not working above expression.

Qrishna — Wed, 25 Apr 2018 17:59:25 GMT

Somehting like this?

gireesh1216 — Wed, 25 Apr 2018 18:26:02 GMT

Yes..How to do that...

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

Qrishna — Wed, 25 Apr 2018 19:40:33 GMT

PSA

sasiparupudi1 — Thu, 26 Apr 2018 07:18:55 GMT

My be try

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

puneetagarwal — Thu, 26 Apr 2018 10:25:06 GMT

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 — Wed, 23 May 2018 05:49:07 GMT

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