topic Re: Need help on How to use count ? in QlikView

Need help on How to use count ?

Mon, 26 Jan 2026 18:19:17 GMT

Hello Everyone,

I need one assistance in creating a formula on counting the no of employee based on their EmpId when 'Type of Program'- value is

'"Occ P.I." , "Occ T.I.", and "Occ TWP". I am currently using this formula-

=((if(ProgramTerm='Occ TWP',Count(EmpId),0)) + (if(ProgramTerm='Occ T.I.',Count(EmpId),0))+(if(ProgramTerm='Occ P.I.',Count(EmpId),0)))

But it is only giving the result count of "Occ TWP". I wanna how to get the total count of this .

Please find attached excel file along with this that contains those values.

Any help would be greatly appreciated !

Thank You !

Re: Need help on How to use count ?

Mark_Little — Fri, 05 Aug 2016 13:22:48 GMT

Try

Count({<[ProgramTerm]={'Occ TWP'},>}DISTINCT EmpId) + Count({<[ProgramTerm]={'Occ T.I'},>}DISTINCT EmpId) +

Count({<[ProgramTerm]={'Occ P.I'},>}DISTINCT EmpId)

Any doubts split them out and check the results.

Mark

Re: Need help on How to use count ?

Anonymous — Fri, 05 Aug 2016 13:29:55 GMT

You can use this also

Count({<[ProgramTerm]={'Occ TWP','Occ T.I','Occ P.I'}>}EmpId)

Re: Need help on How to use count ?

vinieme12 — Fri, 05 Aug 2016 13:37:17 GMT

Count({<[ProgramTerm]={'Occ TWP','Occ T.I','Occ P.I'}>} DISTINCT EmpId) << add distinct if you have duplicates and want to count only unique values

Re: Need help on How to use count ?

Anonymous — Fri, 05 Aug 2016 13:40:56 GMT

please find the QVW as per your requirement .

I am assuming Empid is the field name :Associate Number

Re: Need help on How to use count ?

MindaugasBacius — Fri, 05 Aug 2016 13:49:32 GMT

Check the attachment please for available options.

Re: Need help on How to use count ?

Mon, 08 Aug 2016 12:06:41 GMT

Hi Mark ,

Thanks it is working now. I have one more query of you can help . I and trying to use greater than and less than value like the range of value to count . using this formula-

= Count({<[Length] = {">=63" and "<=84" } >}Distinct Empid)

But it is not working and throwing . Please correct this formula , where and what I am missing ?

Re: Need help on How to use count ?

Mon, 08 Aug 2016 12:07:58 GMT

Hi Vineeth,

Thanks it is working now. I have one more query of you can help . I and trying to use greater than and less than value like the range of value to count . using this formula-

= Count({<[Length] = {">=63" and "<=84" } >}Distinct Empid)

But it is not working and throwing . Please correct this formula , where and what I am missing ?

Re: Need help on How to use count ?

Mon, 08 Aug 2016 12:09:09 GMT

Hi Mindaugas,

Thanks it is working now. I have one more query of you can help . I and trying to use greater than and less than value like the range of value to count . using this formula-

= Count({<[Length] = {">=63" and "<=84" } >}Distinct Empid)

But it is not working and throwing . Please correct this formula , where and what I am missing ?

Re: Need help on How to use count ?

Mon, 08 Aug 2016 12:10:56 GMT

Hi Everyone ,

Thanks it is working now. I have one more query of you can help . I and trying to use greater than and less than value like the range of value to count . using this formula-

= Count({<[Length] = {">=63" and "<=84" } >}Distinct Empid)

But it is not working and throwing . Please correct this formula , where and what I am missing ?

Please help me on this thing also.

Thank You !

Regards,

Animesh

Re: Need help on How to use count ?

vinieme12 — Mon, 08 Aug 2016 12:43:51 GMT

use the below

= Count({<[Length] = {">=63<=84" } >}Distinct Empid)

Re: Need help on How to use count ?

Anonymous — Mon, 08 Aug 2016 14:20:42 GMT

try this

= Count({<[Length] = {">=63<=84" } >}Distinct Empid)