topic Count function in QlikView

Count function

qlikviewwizard — Sun, 19 Jul 2015 11:58:37 GMT

Hi All,

What is the meaning of the below expression?

Count({<[ON/OFF Pathway]={'OFF'} >} Distinct HSP_ACCOUNT_ID), 0)

Re: Count function

sunny_talwar — Sun, 19 Jul 2015 12:03:14 GMT

I think you have a additional (,0)) thing at the end which may be part if statement. But this part (Count({<[ON/OFF Pathway]={'OFF'} >} Distinct HSP_ACCOUNT_ID)) means that you are distinctly counting HSP_ACCOUNT_ID where [ON/OFF Pathway] is OFF

HTH

Best,

Sunny

Re: Count function

qlikviewwizard — Sun, 19 Jul 2015 12:10:43 GMT

Hi sunindia

Thank you for your reply. Yes, I confused with ,0.

Re: Count function

sunny_talwar — Sun, 19 Jul 2015 12:12:30 GMT

Ya I think this expression by itself with ,0) at the end will give you an error.

Re: Count function

Kushal_Chawda — Sun, 19 Jul 2015 12:13:25 GMT

assuming you have expression

alt(Count({<[ON/OFF Pathway]={'OFF'} >} Distinct HSP_ACCOUNT_ID), 0)

First - You are counting the distinct values of HSP_ACCOUNT_ID associated with [ON/OFF Pathway] where value is 'OFF'.

If there is no values of HSP_ACCOUNT_ID associated with [ON/OFF Pathway] alt function returns zero

Re: Count function

qlikviewwizard — Sun, 19 Jul 2015 12:21:07 GMT

Kush141087‌

I am also guessing the same. But it look like if function. But actually not.

Re: Count function

jagan — Mon, 20 Jul 2015 00:24:02 GMT

HI,

I think you missed some part of the expression in the beginning, I guess it would be either If() or Alt(). The above expression counts the Distinct HSP_ACCOUNT_ID which is having ON/OFF Pathway as {'OFF'}.

Hope this helps you.

Regards,

Jagan.

Re: Count function

qlikviewwizard — Mon, 20 Jul 2015 04:44:04 GMT

Hi jagan,Kush141087,

Actual expression was this. It was my mistake not seen keen.

Thank you for your answers.

=If(Getpossiblecount([ON/OFF Pathway])>1 OR [ON/OFF Pathway]='OFF', Count({<[ON/OFF Pathway]={'OFF'} >} Distinct HSP_ACCOUNT_ID), 0)