topic Re: Extract Previous Data in QlikView

Extract Previous Data

pgalvezt — Fri, 15 Jun 2012 19:33:49 GMT

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

Re: Extract Previous Data

Fri, 15 Jun 2012 20:11:39 GMT

Can you please try:

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

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

Re: Extract Previous Data

pgalvezt — Fri, 15 Jun 2012 20:58:37 GMT

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

Re: Extract Previous Data

pgalvezt — Fri, 15 Jun 2012 21:57:10 GMT

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!