topic Using count function in QlikView

Using count function

jyothish8807 — Thu, 28 Mar 2013 07:16:03 GMT

Hi,

I want to count the no of times , two condition are fulfilling for a particular person.

for eg. there are two coloums named " Status" and "Approved " corresponding to different persons.

I want the count coresponding to different persons when status="Done" and Approved="Yes"

iam using the following syntex:

count(if(status='Done' and Approved='Yes',,))

but its not working.....

Regards

Jyothish

Re: Using count function

kaushiknsolanki — Thu, 28 Mar 2013 07:19:01 GMT

Hi,

Try this.

Count({<Status = {"DONE"}, Approved= {"YES"}>} PERSON_ID)

Regards,

Kaushik Solanki

Re: Using count function

Fri, 05 Sep 2014 07:07:06 GMT

hi kaushik

can u plz explain me the syntax you wrote

i have similar problem

thanks in advance

Re: Using count function

Fri, 05 Sep 2014 07:07:34 GMT

hi kaushik

can u plz explain me the syntax you wrote

i have similar problem

thanks in advance

Re: Using count function

Fri, 05 Sep 2014 07:08:02 GMT

could u explain me the syntax.

i have similar problem

thanks in advance

Re: Using count function

deepakqlikview_123 — Fri, 05 Sep 2014 09:02:40 GMT

Hi,

Count({<Status = {"DONE"}, Approved= {"YES"}>} PERSON_ID)

in a a above expression Kaushik used set analysis.

This expression is counting PERSON_ID only where status is done and approved is YES that u r trying for.

Thanks

Re: Using count function

jyothish8807 — Wed, 10 Sep 2014 06:34:21 GMT

Over here Kaushik is using set analysis.

Count function counts the no of possible outcomes.

Set analysis always start with "{" and finish with "}".In "<" you have to write the condition you want.

In the above syntex he is chacking for the entries whose status="Done" and Approved="Yes". He has grouped these condition to Person ID. So now count function will count all the Person_ID which fullfill both status and Approved condition.

Hope this helps you.

Reards

Jyothish KC