topic Re: Count grouped by date in QlikView

Count grouped by date

Mon, 17 Sep 2012 13:01:01 GMT

Hi,

I'm trying to count number of "HayRolling" activities over a specific period, for instance per week.

Activity	DateTimeStamp	Year	Week	Number
HayRolling	14.09.2012 12:04:38	2012	37	1
HorsePlay	14.09.2012 12:00:08	2012	37	1
HayRolling	13.09.2012 15:35:17	2012	37	2
HayRolling	14.09.2012 12:16:00	2012	37	1

So the HayRolling activities should be group and display 4 in this example. Currently the activities are grouped only if the timestamp is identical, as in the 3rd row. My expression:

=Count({$<Activity={"HayRolling"}>} [Year]&[Week])

How can I achieve this please?

Re: Count grouped by date

chematos — Mon, 17 Sep 2012 13:07:43 GMT

Try this:

aggr(Count({$<Activity={"HayRolling"}>} [Year]&[Week]), Year,Week)

or may be with TOTAL:

aggr(Count({$<Activity={"HayRolling"}>} Total [Year]&[Week]), Year,Week)

hope this helps

Re: Count grouped by date

Mon, 17 Sep 2012 13:23:10 GMT

Thanks, José!

Can't spot any differences with or without TOTAL.

Re: Count grouped by date

chematos — Mon, 17 Sep 2012 13:29:36 GMT

Yes, should be the first one but just in case....

You´re welcome