topic Re: QVD should be generated based on time in QlikView

QVD should be generated based on time

Mon, 26 Jan 2026 18:19:17 GMT

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

Re: QVD should be generated based on time

nilesh_gangurde — Thu, 30 Jan 2014 06:42:36 GMT

You can create the 3 seperate extractor for 3 Qvds.

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

-Nilesh

Re: QVD should be generated based on time

Thu, 30 Jan 2014 06:45:33 GMT

Thanks for your quick reply

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

Re: QVD should be generated based on time

jagan — Thu, 30 Jan 2014 07:05:31 GMT

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.