Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
cancel
Showing results for 
Search instead for 
Did you mean: 
saumyashah90
Specialist
Specialist

add time stamp while storing it in qvw

Hi All,

L1:

Load * Inline [

A,a

];

Let x= 'Path'&Today();

Store L1 into $(x).qvd(QVD);

this store command doesnt work.Shows script failed after Let command

Can anyone help

1 Solution

Accepted Solutions
its_anandrjs

Another way is to convert today() into DDMMYYYY format without using ( '/' )  in the date format

L1:

Load * Inline [

A,a

1,2

];

Let x = Date(Today(),'DDMMYYYY');

Store L1 into 'L1 '$(x).qvd(qvd);

Regards

Anand

View solution in original post

8 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Try This:

Store * from L1 into $(x).qvd;


(If you need timestamp use Now() instead of Today()

Not applicable

As Alessandro said u need you utilise now() I would advise to store the timestamp in a field and save daily qvd's to reduce physical disc usage

L1:

Load * Inline [

A,a

];

Let x= 'Path'&Now();

Store L1 into $(x).qvd(QVD);

maxgro
MVP
MVP

2 different ways

L1:

Load * Inline [

A,a

];

Let x= 'Path' & date(Today(),'YYYYMMDD');

trace $(x);

Store L1 into $(x).qvd (QVD);

Let x= 'Path' & date(now(),'YYYYMMDDHHMMSS');

trace $(x);

Store L1 into $(x).qvd (QVD);

its_anandrjs

One way is directly use the Today() function in store

L1:

Load * Inline [

A,a

1,2

];

//Let x = 'Path'& Today();

Store L1 into 'Path '$(Today()).qvd(QVD);

Regards

Anand

its_anandrjs

Another way is to convert today() into DDMMYYYY format without using ( '/' )  in the date format

L1:

Load * Inline [

A,a

1,2

];

Let x = Date(Today(),'DDMMYYYY');

Store L1 into 'L1 '$(x).qvd(qvd);

Regards

Anand

saumyashah90
Specialist
Specialist
Author

Execution failed

saumyashah90
Specialist
Specialist
Author

It makes QVD but its not taking date in the file name

saumyashah90
Specialist
Specialist
Author

This worked fine