YTD, 12RM, Monthly data

[Aspiring_Developer]

Hello All,

I am new to qlik.

I need to calculate YTD, 12RM and max month.

Sample data is

Year	Month	Amount
2018	Jan	1000
2018	Feb	2000
2018	Mar	5000
2018	Apr	100
2018	May	200
2018	June	5555
2018	July	789
2018	Aug	789
2018	Sep	598
2018	Oct	432
2018	Nov	1000
2018	Dec	789
2019	Jan	56000
2019	Feb	6888
2019	Mar	98222
2019	Apr	2344
2019	May	982
2019	Jun	765
2019	Jul	951
2019	Aug	287
2019	Sep	999
2019	Oct	876
2019	Nov	129
2019	Dec	1244

Need to provide to filters to user Month Year & Year .

Problem:

- calculated 12RM but when i set the year filter to maximum i.e year 2020, the value becomes zero .

I thought to remove the Year filter and use only month year filter where maximum month year is always selected. It worked for rolling 12 months . But when  tried to create YTD in bar chart, it shows only the value of current month year selected and does not show the data for all the years.

Please help.

Thanks

-YTD