Qlik Community

Ask a Question

QlikView Documents

QlikView documentation and resources.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY

Creating Daywise QVDs

Kushal_Chawda

Creating Daywise QVDs

Hi Qlikers,

All of you might handling the large Fact tables load from QlikView on daily basis. When there is large Fact table, we always prefer to load the table either with Incremental load or we create day wise QVDs instead of loading the entire table again on daily basis and which is a good practice.

Here, I have a scenario where I have large fact table and I preferred to load the table by creating day wise qvds. I have created the script which will check if QVDs are created or not for particular day. If QVD is created it will not create it again (in for loop)  else it will always create the QVDs for Today, Yesterday and 2 Days ago ( with Today I want to create the yesterday and 2 days ago QVD also as there are some modifications could be done for Yesterday or 2 Days ago data ).

After creating all QVDs you can simply load all the QVDs in QlikView by *.qvd.

Just thought of sharing the script which will be helpful to people who are new to QlikView.

Below is the script highlighted

1.jpg

vDate_i is the variable which is used in where condition while we load the data from source database. Here, one thing should be noted that vDate_i variable format should be same as the Date Field in Source database table, so that the where condition will not fail while loading the data from source database table.

2.jpg

Please find the attached qvw file.

Labels (1)
Attachments
Comments
dmohanty
Partner
Partner

Will be helpful in long run. Thanks for this effort and sharing!

0 Likes
Not applicable

Can U Run This Incremental load Without  Publisher

0 Likes
Kushal_Chawda

shekharchhanda‌You can run this application using windows task scheduler if publisher is not available. If you have qlikview server license then you can run the application from Qemc

0 Likes
ioannagr
Creator III
Creator III

@Kushal_Chawda  kindly look at my issue here

 https://community.qlik.com/t5/New-to-Qlik-Sense/Qvd-for-every-date-in-source-data/m-p/1808964#M18530...

in which i tried to follow this example of yours, but i can't make it work and I thought you could help. Thanks in advance.

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2015-07-22 07:40 AM
Updated by: