Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
KP_1990
Contributor
Contributor

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

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

1 Reply
Anil_Babu_Samineni

Duplicate !!

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful