topic Re: Create a QVD When.... in QlikView

Create a QVD When....

Tue, 22 Jan 2013 15:11:08 GMT

Hi Experts

I really hope you can help me out with this issue

I am loading data in from Excel to Qlikview - but I now have a requirement for data as at a specific value dates - the third working day of the month !!

I was going to try an create a QVD file only on the 3rd working day of the month and save it down with a variable name so I would have each of the Time values. But I am not sure how to script that where function

Below is the very basic script I'm starting with - Any guidance would be greatly appreciated

Thanks a mill

LET vFileDate = Date(Today(), 'YYYYMMDD');

DailyData:
LOAD *
FROM
~~(biff, embedded labels, table is Sheet1$);~~

STORE DailyData INTO $(vFileDate).qvd (qvd);

DROP TABLE DailyData;

AllData:
LOAD Date,
Meat,
Number
FROM *.qvd (qvd);

Re: Create a QVD When....

Tue, 22 Jan 2013 16:40:31 GMT

Hi,

You can add an If - then statement at the end of the script.

It would look something like this:

if num(Day(Today()),00)=03 then

Store SomeTable into SomeTable.qvd(qvd);

ELSE

EXIT Script;

Hope it helps.

Regards,

-Khaled

Re: Create a QVD When....

Tue, 22 Jan 2013 17:07:32 GMT

Thanks Khaled

Re: Create a QVD When....

Tue, 22 Jan 2013 17:07:41 GMT

Thanks Khaled

Re: Create a QVD When....

Tue, 22 Jan 2013 17:14:06 GMT

Thanks Khaled