reloadtime within pathname

shahamel — Tue, 05 Feb 2013 10:45:18 GMT

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

Re: reloadtime within pathname

Tue, 05 Feb 2013 13:19:16 GMT

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

topic reloadtime within pathname in QlikView

reloadtime within pathname

Re: reloadtime within pathname