Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
A running YTD can't be done with set analysis expressions. See this document: Calculating rolling n-period totals, averages or other aggregations
A running YTD can't be done with set analysis expressions. See this document: Calculating rolling n-period totals, averages or other aggregations
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)
Hi,
please find the updated qlikview application with correct YD result.
Thanks,
Rahul