Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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])

1 Solution

Accepted Solutions
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')

View solution in original post

10 Replies
MayilVahanan

Hi,

     Try this,

          =Count({<Priority= {'High'},[Request Status]= {'Closed'}>} Distinct[Case Id])

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
alexpanjhc
Specialist
Specialist

Will this work?

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

Not applicable
Author

Sorry Alex it doesnt work

alexpanjhc
Specialist
Specialist

then it is better using set analysis?

=Count({<Priority= {'High'}>} Distinct[Case Id])-Count({<Priority= {'High'},[Request Status]= {'Closed'}>} Distinct[Case Id])

MayilVahanan

HI,

Did u try this..

=Count({<Priority= {'High'}>} Distinct[Case Id])-Count({<Priority= {'High'},Request Status]={ 'Closed'} Distinct[Case Id])

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

yes but it does work ;-(

Not applicable
Author

Sorry it doesnt work.

alexpanjhc
Specialist
Specialist

When you said it is not working, does that mean the number was not right? or it is not doing what you want?

Maybe you just try to see if Count({<Priority= {'High'}>} Distinct[Case Id]) can get u a right number?

somenathroy
Creator III
Creator III

Count({<Priority= {'High'},[Request Status]= - {'Closed'}>} Distinct[Case Id])