accumulated sum

[ilanbaruch]

Hi all,

in my model i have an expression which is working well in a straight table ,

within the straight table, when user select Apr-18 in the calendar the expression will retrieve the sum of all Sales below the max date (04/30/2018).

i want to use this kind of expression with month dimension (chart or a table) , but it is not working as i need the accumulated sum per each month.

sum({$<ValueDate=,YearMonth=, Year=,Month=,Group={50,51},Date= {"<=$(vPossibleDates)"} > } Sales)

vPossibleDates = date(max(ValueDate))

any ideas ?

advanced thanks 

[vvira1316]

AsOf Calendar table is usually very helpful for accumulation. Please refer following link

https://community.qlik.com/t5/QlikView-Documents/Calculating-rolling-n-period-totals-averages-or-oth...