Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: Count only open high priority tickets

 

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

10 Replies

Re: Count only open high priority tickets

Hi,

     Try this,

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

Hope it helps

alexpanjhc
Valued Contributor

Re: Count only open high priority tickets

Will this work?

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

Not applicable

Re: Count only open high priority tickets

Sorry Alex it doesnt work

alexpanjhc
Valued Contributor

Re: Count only open high priority tickets

then it is better using set analysis?

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

Re: Count only open high priority tickets

HI,

Did u try this..

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

Not applicable

Re: Count only open high priority tickets

yes but it does work ;-(

Not applicable

Re: Count only open high priority tickets

Sorry it doesnt work.

alexpanjhc
Valued Contributor

Re: Count only open high priority tickets

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
Contributor III

Re: Count only open high priority tickets

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

Community Browser