Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
amien
Specialist
Specialist

simple aggr and rangesum(before) question

i have these dimensions: group, filenumber, date

expression: rangesum(before(payment, 0, ColumnNo()))

now:

i want to leave out the filenumber dimension.. but the expression should still give the sum of the rangesum based on the filenumber

SUM(AGGR(rangesum(before(payment, 0, ColumnNo())),filenumber)

is not working

1 Reply
Not applicable

Perhaps you need a set analysis statement that doesn't select any filenumber.

Like this statement


rangesum({$<filenumber = >} before(payment, 0, ColumnNo())


I doubt the exact code will work, but I hope it helps to find the correct one