- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
QVD should be generated based on time
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
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can create the 3 seperate extractor for 3 Qvds.
and schedule the extractor on Qlikview Server on the 3 differnet timings.
-Nilesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for your quick reply
Due to some reasons I am supposed to maintain only one QVD Generator instead of three
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.