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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Get sum of values, which less date in dimension

I have some dimensions and one of it is date. Also I have a few volumes for each date. I need to get sum of volumes, for which date less then in dimension.

For example

Dim 1, Dim 2, Date, volume, sum of volumes less date

A,         AA,.       6,.     15,.             0

A,.        AB,.       7,.       5,              30

B,.        BA,.       6,.       15,.            0

B,.         BB,.      8,.        10,.           35


I can't understand how to compare dates for each row with date in dimension and get sum.

11 Replies
qliksus
Specialist II
Specialist II

May be something like this

sum(aggr( rangesum(above(sum(volume),0,RowNo(TOTAL) )) - sum(volume) ,Date))


vinieme12
Champion III
Champion III

what is the expected output?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.