QVD should be generated based on time

[#1]

Hello all,

I created a QVD generator which generates 3 QVD's . Each QVD consists of minimun 5 countries data which are filtered using 'Where Exists' command in script .

Now  each QVD should be generated at some specific time . For example 1st QVD at 5:00 AM  , 2nd QVD at 10:00PM and 3rd QVD at 5:00PM ..

How can I work on this?

Any help would be appreciated.

Thanks in advance

Best Regards,

Senthil

[nilesh_gangurde]

You can create the 3 seperate extractor for 3 Qvds.

and schedule the extractor on Qlikview Server on the 3 differnet timings.

-Nilesh

[#3]

Thanks for your quick reply

Due to some reasons I am supposed to maintain only one QVD Generator instead of three

[jagan · Accepted solution]

Hi Senthil,

You create script like this using If

If Hour(Now()) = 5 then

--------------Load script goes here for first QVD

else if Hour(Now()) = 13 then

-------------Load script goes here for second QVD

else if Hour(Now()) = 20 then

-------------Load script goes here for third QVD

end if

Now schedule to reload in Console three times daily at 5AM, 1PM and 8PM.

Hope this helps you.

Regards,

Jagan.