Qlik Community

Ask a Question

Community Corner

Discussion board for questions about the Qlik Community, its features, sharing information, general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!

Announcements
BARC's BI & Analytics Annual Survey 22: TAKE SURVEY
cancel
Showing results for 
Search instead for 
Did you mean: 
abhinav_pandey0
Contributor III
Contributor III

partial reload

What is Partial Reload?

What is the difference between ADD and ADD Only keyword?

What is IsPartialReload()?

1 Solution

Accepted Solutions
12 Replies
abhinav_pandey0
Contributor III
Contributor III
Author

Thanks Manish...

But I am confused in IsPartialReload().

Thanks in Advance.

colin_albert

This is what Help says about IsPartialReload

IsPartialReload( )

Returns - 1 (true) if the current reload is partial, otherwise 0 (false).

abhinav_pandey0
Contributor III
Contributor III
Author

thanks Colin, but how to implement it.

colin_albert

These videos may help - the second video uses IsPartialReload()

Partial Reload in QlikView - YouTube

Partial Reload in QlikView - Part II - YouTube

sudeepkm
Specialist III
Specialist III

When you create a task in QMC for your QVW,  you will find an option to select "Partial Reload" under Reload tab.

If Partial Reload is enabled in a task for a QVW then the IsPartialReload() function in the QVW's script returns true.

Given below is a sample script.

In the script given below I'm trying to load data from QVD to my Main UI QVW whenever the QVD created in the past 30 min.

vqvdtime is for the QVDCreation time and vnowtime is the time for past 30 min.

So if my QVD is not created recently then the script will exit.

I can have two task created for this same QVW one Partial Reload runs every 30 min and

another task with full reload runs every 4 hours.

if IsPartialReload() then

    if '$(vqvdtime)'>='$(vnowtime)' then

        Replace load * from tabl.qvd(qvd); // The qvd has fresh data to be loaded

        TRACE 'QVD refreshed recently so all data from QVD should be loaded';

    ELSE

        TRACE 'No data to be loaded as the QVD not created recently';

        EXIT Script; // do nothing

       

    ENDIF

ELSE

        load * from tabl.qvd(qvd); // no Partial reload

        TRACE 'Not a Partial reload and all data to be loaded';

ENDIF

abhinav_pandey0
Contributor III
Contributor III
Author

Thanks a lot Sudeep.

IAMDV
Luminary
Luminary

Hi Abhivav,

I've made two part video tutorials on Partial Reload. Please check the below link (Copy & Paste the URL)

http://qlikshare.com/370

Thanks,

DV

abhinav_pandey0
Contributor III
Contributor III
Author

Thanks Deepak.Quite helpful videos.