topic Re: Expression Revies in QlikView

Expression Revies

Fri, 22 Nov 2013 19:19:06 GMT

I had created Flag , i need to count only the flag=ncr and ncr type=RI

Need expression for that..

=(count(distinct([Lot Number]))- count(DISTINCT([EW Lot Number]))) / count(DISTINCT([Lot Number]))

Re: Expression Revies

Clever_Anjos — Fri, 22 Nov 2013 19:25:49 GMT

=(count(distinct {<flag={'ncr','RI'}>}[Lot Number])- count(DISTINCT {<flag={'ncr','RI'}>}[EW Lot Number])) / count(DISTINCT {<flag={'ncr','RI'}>}([Lot Number]))

Re: Expression Revies

Fri, 22 Nov 2013 19:48:53 GMT

Tanq ..

My requirment is i need to calucalte the LAR RATE AND SCAR RATE ..

Some suppliers has scars and some supplier has Lar ..

In the same pivot table i need to calculate for the suppliers their scar rate and Lar rate

To show the user more specific which supplier has scar and lar

And i also need to show the conditional formatting .IF scar is >98 some colour

and also lar >95 some colour ..

Please find screen shot