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

KP_1990 — Mon, 29 Apr 2019 11:11:46 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:16:16 GMT

Duplicate !!

topic Re: 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

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