Running YTD

[#1]

Hi,

I need to create a report that lists monthly cost analysis which also has additional column for YTD. This should be running YTD.

i am trying to use expression =(sum({$<  MonthID = {"<=$(=max(MonthID))"},Month=,Year=  >} Cost))

but it's not working properly. Find attached files.

please suggest solution.

Regards,

Rahul

[Gysbert_Wassenaar · Accepted solution]

A running YTD can't be done with set analysis expressions. See this document: Calculating rolling n-period totals, averages or other aggregations

[#3]

How come? I have a set analysis taking last6month.

I would believe i could make a CYTD ?

Edit: did not see it should add months up. (running)

[#4]

Hi,

please find the updated qlikview application with correct YD result.

Thanks,

Rahul