Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Showing results for 
Search instead for 
Did you mean: 
neerajthakur
Creator III
Creator III

where clause in qlik sense expression with count

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

Thanks & Regards,
Please Accepts as Solution if it solves your query.
1 Reply
Or
MVP
MVP

Count({< Status = {'Accepted'} >} [NOC No])