Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count only open high priority tickets

I'm using the below formula on a chart. I'm trying to count a total of cases with high priority which current status is not closed. HELP!!!!

=Count(Priority= 'High' and [Request Status]= 'Closed', Distinct[Case Id])

10 Replies
Not applicable
Author

 

After multiple attemps the formula below works.

=Num(Count({1<[Request Status]={'Assigned'}>}[Case Id]),'#,##0') +Num(Count({1<[Request Status]={'Pending'}>}[Case Id]),'#,##0')+ Num(Count({1<[Request Status]={'Unassigned'}>}[Case Id]),'#,##0')+Num(Count({1<[Request Status]={'Sent to ITServus'}>}[Case Id]

),'#,##0')