Last 25 Months in a single table

[mhmmd_srf]

Hi All,

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.

Thanks,

Sarif

[nabhiram]

Hi Mohammad,

links below will help you

https://community.qlik.com/docs/DOC-9144

https://community.qlik.com/docs/DOC-9162

Thanks

Abhiram

[tresesco · Accepted solution]

Try like:

Load

  Date(MonthStart(Today(),-RowNo()+1), 'YYYY-MMM') as Prior_Months

AutoGenerate 25;