Extract Previous Data

[pgalvezt]

Hi, I had connected QlikView in our ERP System and I need to extract some periods like May-2011 And Jun-2011. Also I need to extract This Month and the Previous Month. I have this but Works for this year.

LET vCurrentMonth = Month(Today());

LET vPreviousMonth = Month(Today(), -1));

How can I extract May-Jun 2011?

Thanks

[#2]

Can you please try:

=date(addmonths(Today(), -12), 'MMM-YYYY')

=date(addmonths(Today(), -13), 'MMM-YYYY')

[pgalvezt]

QlikView returns 0 registers:

I have a Where Clause:

Let xxPeriodo = date(addmonths(Today(),-13), 'MMM-YYYY');

If I put

Let xxPeriodo = 'MAY-2011'; QlikView read the information

Where

sa.PERIOD_NAME = '$(xxPeriodo)'

But Doesn't Work.

Thanks

[pgalvezt]

Hi, I took the where Clause and now works thanks. But is there any way to left this automatically. I mean, without change the period.

Thanks!