Solved: diffence between ytd and rolling n months - Qlik Community

sekharapp · ‎2022-05-16

what is the diffence between ytd expression and rolling n months expression?

can you give some examples?

vinieme12 · ‎2022-05-16

As below

YTD = from 1st Jan to the latest date the data is available

Rolling = Cumulative totals for a given period

for example, the below is Rolling YTD, every month you sum up values from previous month

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

vinieme12 · ‎2022-05-16

As below

YTD = from 1st Jan to the latest date the data is available

Rolling = Cumulative totals for a given period

for example, the below is Rolling YTD, every month you sum up values from previous month

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

sekharapp · ‎2022-05-17

can you post some expressions for rolling ytd

vinieme12 · ‎2022-05-17

=rangesum( above( sum(Sales),0,rowno(total)) )

Refer these articles

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

diffence between ytd and rolling n months