Discussion board where members can get started with Qlik Sense.
I want to create a Table call Prior Months. The field name would be Prior_Month. Where data would be last 25 months based upon current month dynamically.
Like today is 25th Oct, so current month is 2016-Oct. And the Month would be like bellow:
I created above one using Inline Load. But I want this dynamically.
Go to Solution.
Date(MonthStart(Today(),-RowNo()+1), 'YYYY-MMM') as Prior_Months
links below will help you