topic Re: Limit Load QVDs in QlikView

Limit Load QVDs

Mon, 22 Oct 2012 09:44:01 GMT

Hi All,

I have a problem when I want to limit qvd to concatenate into one qvd. For example I have 5 QVD history (Table_Jan2012, Table_Feb2012, Table_Mar2012, Table_Apr2012, Table_May2012). Every table created in the last days of month.

We all know, we can use wildcard (*) if we want to load all QVD directly (Table_*.qvd) and concatenateed into one qvd..

But in this case I want to load only last 3 QVD history automatically (Table_Mar2012, Table_Apr2012, Table_May2012), and save it into one qvd. And next month the script load only Table_Apr2012, Table_May2012, and Table_Jun2012;

Anyone know how to make it?

Thanks before.

Regards,

Heri

Re: Limit Load QVDs

Mon, 22 Oct 2012 09:46:59 GMT

Maybe have a look at the addmonth function

Let vTodayMinusThree = addmonths('$(vMaxDate)',-3);

Re: Limit Load QVDs

Mon, 22 Oct 2012 09:54:29 GMT

thanks brianm for your respon,

I dont think its can solve my problem, because the QVDs name is in string format.

Table_Mar2012 --- Mar2012 is string format..

regards,

Heri

Re: Limit Load QVDs

Mon, 22 Oct 2012 10:39:20 GMT

You could possibly try renaming the QVDs

Then try using the date function