Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

3 month running(sliding) count

Hello guys,

Need your help.

Have a list of users (a,b,c,d) that each month might have or have not some activity. I need each month to count how many users had activity during last 3 months (including current month).

!!!This table is just to demonstrate how the users should be counted. Actual data structure is a bit different and is in the attachment!!!

monthabcd# of users with activity
Jan-131113
Feb-131113
Mar-13113
Apr-1313
May-1312
Jun-1311
Jul-1311
Aug-1311
Sep-13112
Oct-13112
Nov-13112
Dec-131113

Thanks a lot in advance.

7 Replies
Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks man. Unfortunately it's not an option for me to use load scripts I simply do not have rights for that. I can only use chart expressions.

Not applicable
Author

See attached.

Cheers.

Not applicable
Author

Hi Christopher. Thanks. Something wrong with your formula. It doesn't count users the way I need.

Greenshot_2013-09-23_10-49-46.jpg

Not applicable
Author

Ok.  What should the numbers be?  You said count the number of users for the past 3 months.  So for month 01.01.2013 its 3 + 3 + 2 = 8.  01.02.2013 = 3 + 2 + 1 = 6.

Not applicable
Author

Hi:) The right counting is shown in this table. Ones ('1') are meant to show whether user had or not activity in the respective month. For instance in January 2013 users a, b,d had activity while c did not. "# of users with activity" here shows correct counting (in Jan there were 3 users that had activity in last 3 months). Hope it's clearer now.

monthabcd# of users with activity
Jan-131113
Feb-131113
Mar-13113
Apr-1313
May-1312
Jun-1311
Jul-1311
Aug-1311
Sep-13112
Oct-13112
Nov-13112
Dec-131113
Not applicable
Author

try

aggr(sum(activity),date)