topic Re: Count issue in QlikView

Count issue

Mon, 18 Mar 2013 13:43:25 GMT

I am looking to count the total number of ID where ADM = YES and each ID has a start date SD. Have a calendar setup. Ideally Example: when the year = 2011 , Month = August and Day = 08 is selected the result should be 2. Set analysis to be used?

ID SD

f5464 01/08/2011

w4578 04/05/2006

q4579 01/08/2011

r4565 04/07/2006

k4546 06/05/2009

q5657 15/01/2006

g4576 14/03/2001

Regards,

Koushik.

Re: Count issue

Mon, 18 Mar 2013 13:48:34 GMT

Hi,

You can aggr().

AGGR(COUNT(ID),SD))

Re: Count issue

Gysbert_Wassenaar — Mon, 18 Mar 2013 14:24:48 GMT

count({<ADM={'YES'},SD={'*'}>} distinct ID) will count all distinct ID's where ADM = YES and SD is not null.

Re: Count issue

Tue, 19 Mar 2013 14:45:59 GMT

Have a field ARRIVAL_DATE which controls the calendar in addition to the above data. Ideally I am looking to match ARRIVAL_DATE to SD and count the number of ID where ADM = YES.