Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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