Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

partial reload

What is Partial Reload?

What is the difference between ADD and ADD Only keyword?

What is IsPartialReload()?

1 Solution
12 Replies
Anonymous
Not applicable
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).

Anonymous
Not applicable
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

Anonymous
Not applicable
Author

Thanks a lot Sudeep.

IAMDV
Luminary Alumni
Luminary Alumni

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

Anonymous
Not applicable
Author

Thanks Deepak.Quite helpful videos.