topic Running YTD in QlikView

Running YTD

Tue, 13 Aug 2013 10:48:15 GMT

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 — Tue, 13 Aug 2013 10:53:35 GMT

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

Tue, 13 Aug 2013 11:11:56 GMT

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)

Tue, 13 Aug 2013 14:13:18 GMT

Hi,

please find the updated qlikview application with correct YD result.

Thanks,

Rahul