Skip to main content
Announcements
Document boards are being consolidated, this board no longer allows NEW documents READ MORE

Creating Daywise QVDs

cancel
Showing results for 
Search instead for 
Did you mean: 
Kushal_Chawda

Creating Daywise QVDs

Last Update:

Sep 26, 2024 11:31:29 AM

Updated By:

Kushal_Chawda

Created date:

Jul 22, 2015 7:40:36 AM

Attachments

Many of you might be handling large fact table loads in QlikView on a daily basis. When dealing with large fact tables, it’s best practice to either use an incremental load or create daywise QVDs instead of reloading the entire table each day.

In my case, I had a large fact table, and I opted to load the table by creating daywise QVDs. I developed a script that checks whether QVDs have already been created for a particular day. If a QVD exists, it won't be recreated (within the loop). However, the script will always create QVDs for today, yesterday, and two days ago—since there could be modifications in the data for those days.

After generating all the necessary QVDs, you can simply load them into QlikView using *.qvd.

I wanted to share this script as it might be helpful to those 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.

Tags (1)
Labels (1)
Comments
dmohanty
Partner - Specialist
Partner - Specialist

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
Last update:
‎2024-09-26 11:31 AM
Updated by: