topic Re: loading qvds in QlikView

loading qvds

prabhas277 — Sun, 20 Sep 2015 08:30:52 GMT

Hi Experts,

I have monthly qvds like jan,feb,... Dec now my requirement is if i load 7th month qvd then at the same i want load previous month last day qvd i.e 6th month 30 th or 31 th qvd. how can get it?

Re: loading qvds

ecolomer — Sun, 20 Sep 2015 08:58:02 GMT

Can you explain more details, please?

Re: loading qvds

prabhas277 — Sun, 20 Sep 2015 09:07:32 GMT

Hi,

I have monthly Qvds like jan,fed,march,apr,....dec. The monthly qvd having all day qvds like 1st,2nd,3rd...31st day qvds. now my requirement is i want load 5 th month Qvd and same time i want load previous month last day qvd i.e 4th month 31 st day qvd. how can achive it?

Re: loading qvds

ecolomer — Sun, 20 Sep 2015 09:11:21 GMT

but that means having a qvd for each day or one for each month with a record for each day?

Re: loading qvds

Anonymous — Sun, 20 Sep 2015 11:17:32 GMT

hi prabhas,

Maybe try:

Let vMinMonth = AddMonths(MonthEnd(Today()),-1);

For Each vFile in FileList('...\...\Data*.qvd')

Let vBaseFilename = Substring(vFile, '\', -1);

Let vDate = Date#(Mid(vBaseFilename, 6, 6));

If vDate >= vMinMonth Then

Data:

LOAD *

FROM [$(vFile)] (qvd);

End If

Regards

Neetha