topic Re: Count only open high priority tickets in QlikView

Count only open high priority tickets

Fri, 06 Jul 2012 18:28:18 GMT

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

Re: Count only open high priority tickets

MayilVahanan — Fri, 06 Jul 2012 18:33:33 GMT

Hi,

Try this,

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

Hope it helps

Re: Count only open high priority tickets

alexpanjhc — Fri, 06 Jul 2012 18:37:00 GMT

Will this work?

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

Re: Count only open high priority tickets

Fri, 06 Jul 2012 19:07:01 GMT

Sorry Alex it doesnt work

Re: Count only open high priority tickets

alexpanjhc — Fri, 06 Jul 2012 19:10:09 GMT

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

MayilVahanan — Fri, 06 Jul 2012 19:23:58 GMT

HI,

Did u try this..

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

Re: Count only open high priority tickets

Fri, 06 Jul 2012 19:43:05 GMT

yes but it does work ;-(

Re: Count only open high priority tickets

Fri, 06 Jul 2012 20:03:41 GMT

Sorry it doesnt work.

Re: Count only open high priority tickets

alexpanjhc — Fri, 06 Jul 2012 21:13:46 GMT

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?

Re: Count only open high priority tickets

somenathroy — Sat, 07 Jul 2012 12:10:03 GMT

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

Re: Count only open high priority tickets

Mon, 16 Jul 2012 17:25:07 GMT

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