Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Create a QVD When....

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

1 Solution

Accepted Solutions
Not applicable

Re: Create a QVD When....

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

4 Replies
Not applicable

Re: Create a QVD When....

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

Not applicable

Re: Create a QVD When....

Thanks Khaled

Not applicable

Re: Create a QVD When....

Thanks Khaled

Not applicable

Re: Create a QVD When....

Thanks Khaled