Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Re: Running YTD

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
3 Replies

Re: Running YTD

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

Re: Running YTD

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

Re: Running YTD

Hi,

please find the updated qlikview application with correct YD result.

Thanks,

Rahul

Community Browser