topic Need to accumulate till selected month for that Year in QlikView

Need to accumulate till selected month for that Year

shabarish0587 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys,

I need one help. i want to display accumulated data based on selection.

for example if i select 2019-06, it should accumulate value from 2019-01 to 2019-06 and divided by count of year month value in chart. for example:

2019-01,2019-02,2019-03,2019-04,2019-05,2019-06

100,200,400,300,100,200

Total accumulation is 1300 till 2019-06 divided by 6(number of months till selected) expected answer is 216. can any one help me how to write the expression on this

Re: Need to accumulate till selected month for that Year

Victor_Alumanah — Tue, 15 Oct 2019 11:03:03 GMT

This may help, MTD

Re: Need to accumulate till selected month for that Year

vhespinog — Thu, 17 Oct 2019 21:02:34 GMT

May be this

=sum({$<YearMonth={">=$(=Date(YearStart(YearMonth,0),'YYYY-MM')) <=$(=Max(YearMonth))"}>}Amount)
/
Num(Month(Max(YearMonth)))

see attached