How to get YTD values using MTD field in qlikview?

[srinivas1921]

Hi All,

we have Amount_MTD and Amount_ITD field are available in database but not available Amount_YTD. As per requirement we need to display MTD,YTD,ITD views in bar chats and we able to show MTD and ITD view but not YTD due to not available in the database.

top of dashboard we have created Year and Month filters and according to these filters we need to show YTD values in the dashboard.

So please suggest that how to create YTD expression using MTD amount.

Note:  there is no amount field available in the database to create YTD. Only amount_MTD and amount_ITD field available in the database.

thanks........................

[MK_QSL]

It would be better if you have provided sample data to work or sample application.

If possible, also provide your required output.

[agomes1971]

Hi,

please read this:

Calculating rolling n-period totals, averages or other aggregations

I hope you have at least a field that indicates which month it referes to...

HTH

André Gomes