Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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])