Create a Master Calendar using Month and Year field in Data set and Show Sales for a Year

[KP_1990]

Hi Guys,

I need to create a master calendar using the month and year field provided in data source I don't have a date field what is the best possible way to create the master calendar in this situation ?

Secondly I need to show Sales for  a year using this and in front end we just have month and year filter and not date filter so selecting a month and then year should give me the sales from that monthyear till last one.

Eg: if I select Mar 2018 I should see sales from Apr 2017 till Mar 2018.

Please help me with the same.

Thanks

[Anil_Babu_Samineni]

How is your "Financial Year" - Is that from Apr - Mar?

[imrasyed]

May be try this

Sum({<YearMonth={">=$(=Addyear(Max(YearMonth),-1)) <=max(YearMonth)"}>}Sales)

[Brett_Bleess]

Not sure if you got things sorted or not, but below is a Design Blog post on Fiscal Year that may be of some help to you.

https://community.qlik.com/t5/Qlik-Design-Blog/Fiscal-Year/ba-p/1472103

Here is one on Master Calendar as well:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527

Regards,
Brett