Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Running YTD

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

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Not applicable
Author

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)

Not applicable
Author

Hi,

please find the updated qlikview application with correct YD result.

Thanks,

Rahul