topic Re: Creating Qvd With The Latest Reload Time as its Name in Qlik Learning Discussions

Creating Qvd With The Latest Reload Time as its Name

umartareen — Sun, 22 Feb 2015 08:17:04 GMT

Hi,

I am looking to create Qvds with the last reload time as their name.

So every time I reload the application, a new Qvd is generated for the same table in the same folder but with new date and time without overriding the previous generated Qvd.

In short, I have to generate a new Qvd for every reload with reload date and time as their name.

Any ideas, please help,

Thanks and Regards

Umar

Re: Creating Qvd With The Latest Reload Time as its Name

marcus_sommer — Mon, 23 Feb 2015 11:38:21 GMT

Try something like this:

let vDateTime = now();

....

store table into table_$(vDateTime).qvd (qvd);

Maybe you need some additional formating for vDateTime to sort in a certain order and to avoid not allowed chars like ":" between hours and minutes.

- Marcus

Re: Creating Qvd With The Latest Reload Time as its Name

umartareen — Mon, 23 Feb 2015 12:12:45 GMT

Hi, thank you for the reply.

I tried this way, but the qvd that is generated has its name as Table_.qvd.

It is not recording the date and time. I tried the Now() function as you suggested and also ReloadTime().

I have even changed the set variables Dateformat, Timeformat and Timestampformats from (:) to (_), just in case the date and time do not appear.

Re: Creating Qvd With The Latest Reload Time as its Name

maxgro — Mon, 23 Feb 2015 12:28:41 GMT

table:

load rowno() as id

AutoGenerate 100;

let vDateTime = date(now(), 'YYYYMMDD_hhmmss');

let vFileName = '$(vDateTime)_table.qvd';

if len(trim(FileSize('$(vFileName)')))>0 then

trace file exists;

ELSE

trace 'file doesnt exists, store';

trace $(vFileName);

store table into '$(vFileName)' (qvd);

ENDIF;

if len(trim(FileSize('$(vFileName)')))>0 then

trace file exists;

ELSE

trace 'file doesnt exists, store';

trace $(vFileName);

store table into '$(vFileName)' (qvd);

ENDIF;

Re: Creating Qvd With The Latest Reload Time as its Name

umartareen — Mon, 23 Feb 2015 13:08:19 GMT

Great, thank you !