Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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