Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to find Total NOC/NOC, here NOC is where NOC Status is Accepted
Total NOC - Count([NOC No])
NOC - Count([NOC Status] where Status='Accepted')
How can I write an expression for this KPI in QlikSense, above expression is rough to explain the question
Similarly I have to find Success Ratio of NOC
Count({< Status = {'Accepted'} >} [NOC No])