Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
markgraham123
Specialist
Specialist

Store qvd at 11 am run

Hi All,

I'm trying to make a conditional store statement which stores the qvd, when the report runs at 11 am schedule.

Here is the code I'm using:

Table1:

LOAD * Inline

[

ID,Name

1,A

2,B

3,C

];

IF (Time(Now(), 'hh')='11') THEN

STORE Table1 into 11amData.qvd;

ELSE

ENDIF

Any help is highly appreciated.

1 Solution

Accepted Solutions
Not applicable

Hi Mark,

Can you please use the below script I can able to generate the qvd file.

Table1:

LOAD * Inline

[

ID,Name

1,A

2,B

3,C

];

let time=Time(now(),'hh');

if $(time)='22'  then

store Table1 into D:\22am.qvd;

endif

Thanks,
Sreeman

View solution in original post

5 Replies
Chanty4u
MVP
MVP

what error  ur getting?

markgraham123
Specialist
Specialist
Author

Chanty,

Its executing, but no qvd is getting stored.

Chanty4u
MVP
MVP

may be dis will help u

need to store job failed time in qvd

Not applicable

Hi Mark,

Can you please use the below script I can able to generate the qvd file.

Table1:

LOAD * Inline

[

ID,Name

1,A

2,B

3,C

];

let time=Time(now(),'hh');

if $(time)='22'  then

store Table1 into D:\22am.qvd;

endif

Thanks,
Sreeman

markgraham123
Specialist
Specialist
Author

Thanks Sreeman.

I tried Hour(Now())=11

It also worked,.

Thanks again for your help!