Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

markgraham123
Contributor II

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

Re: Store qvd at 11 am run

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

5 Replies
sureshqv
Esteemed Contributor III

Re: Store qvd at 11 am run

what error  ur getting?

markgraham123
Contributor II

Re: Store qvd at 11 am run

Chanty,

Its executing, but no qvd is getting stored.

sureshqv
Esteemed Contributor III

Re: Store qvd at 11 am run

may be dis will help u

need to store job failed time in qvd

Not applicable

Re: Store qvd at 11 am run

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
Contributor II

Re: Store qvd at 11 am run

Thanks Sreeman.

I tried Hour(Now())=11

It also worked,.

Thanks again for your help!

Community Browser