Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mhmmd_srf
Contributor II

Last 25 Months in a single table

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Last 25 Months in a single table

Try like:

Load

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

AutoGenerate 25;

2 Replies
nabhiram
New Contributor III

Re: Last 25 Months in a single table

MVP
MVP

Re: Last 25 Months in a single table

Try like:

Load

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

AutoGenerate 25;