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

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

KP_1990 — Wed, 25 Nov 2020 16:16:04 GMT

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

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

Anil_Babu_Samineni — Mon, 29 Apr 2019 13:07:29 GMT

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

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

imrasyed — Mon, 29 Apr 2019 14:04:03 GMT

May be try this

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

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

Brett_Bleess — Wed, 19 Jun 2019 20:27:44 GMT

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