Create a QVD When....

[#1]

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

A

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);

[#2 · Accepted solution]

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

[#3]

Thanks Khaled

[#4]

Thanks Khaled

[#5]

Thanks Khaled