Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Could someone help me please?
I would like to have reloadtime() within my pathname
THis is my current script
SET
ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='€ #.##0,00;€ -#.##0,00';
SET TimeFormat='h:mm:ss';
SET DateFormat='D-M-YYYY';
SET TimestampFormat='D-M-YYYY h:mm:ss[.fff]';
SET MonthNames='jan;feb;mrt;apr;mei;jun;jul;aug;sep;okt;nov;dec';
SET DayNames='ma;di;wo;do;vr;za;zo';
SET Pad = 'U:\Basis\Qlikview - Sandeep\Now()';
SET Reloadtime = Now();
TEST:
LOAD
JAAR,
NIVEAU
FROM
Niveautest.xlsx
(ooxml, embedded labels, table is Blad1);
STORE TEST INTO [$(Pad)-test.qvd] (qvd);
try like this:
SET Pad = 'D:\';
LET Reloadtime = PurgeChar( utc(),':');
TEST:
LOAD * INLINE [
wed, qwerty
com.mytest3, 1
com.mytest2, 50
];
STORE TEST INTO $(Pad)$(Reloadtime)test.qvd (qvd);