Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression Revies

  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]))

2 Replies

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

Not applicable

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

scar lar.PNG