Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
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
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
Thanks Khaled
Thanks Khaled
Thanks Khaled