Store qvd at 11 am run

[markgraham123]

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.

[Chanty4u]

what error  ur getting?

[markgraham123]

Chanty,

Its executing, but no qvd is getting stored.

[Chanty4u]

may be dis will help u

need to store job failed time in qvd

[#5 · Accepted solution]

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]

Thanks Sreeman.

I tried Hour(Now())=11

It also worked,.

Thanks again for your help!