Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

report with accumulation

I have table of users as:

Logindate_register (mm-dd-yyyy)
user101-01-2013
user201-02-2013
user301-01-2013
user401-02-2013
user501-03-2013
......

I need to make report as:

date (mm-dd-yyyy)Count of users
01-01-20132
01-02-20134
01-03-20135
......

If i select '01-02-2013' and '01-03-2013', i want to see this report as:

date (mm-dd-yyyy)Count of users
01-02-20134
01-03-20135

How i may make it? (If i check accumulation checkbox in expression i have counts of user for 01-02-2013 = 2 and for 01-03-2013=3 )

1 Solution

Accepted Solutions
swuehl
MVP
MVP

You can use rangesum(above(count(FIELD),0,rowno())) to emulate the full aggregation, and then add advanced aggregation to limit the values to your selection (this requires that your date field's load order is sorted chronologically, as in your sample data).

See attached.

View solution in original post

2 Replies
swuehl
MVP
MVP

You can use rangesum(above(count(FIELD),0,rowno())) to emulate the full aggregation, and then add advanced aggregation to limit the values to your selection (this requires that your date field's load order is sorted chronologically, as in your sample data).

See attached.

Not applicable
Author

Ty for rapid answer