topic Re: partial reload in Water Cooler

partial reload

Anonymous — Thu, 06 Mar 2014 09:23:30 GMT

What is Partial Reload?

What is the difference between ADD and ADD Only keyword?

What is IsPartialReload()?

Re: partial reload

MK_QSL — Thu, 06 Mar 2014 09:25:01 GMT

What is meant by partial reload? What is its use? Please explain!

Re: partial reload

Anonymous — Thu, 06 Mar 2014 09:30:45 GMT

Thanks Manish...

But I am confused in IsPartialReload().

Thanks in Advance.

Re: partial reload

Colin-Albert — Thu, 06 Mar 2014 09:34:48 GMT

This is what Help says about IsPartialReload

IsPartialReload( )

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

Re: partial reload

Anonymous — Thu, 06 Mar 2014 09:40:51 GMT

thanks Colin, but how to implement it.

Re: partial reload

Colin-Albert — Thu, 06 Mar 2014 09:49:32 GMT

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

Partial Reload in QlikView - YouTube

Partial Reload in QlikView - Part II - YouTube

Re: partial reload

sudeepkm — Thu, 06 Mar 2014 09:50:27 GMT

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

Re: partial reload

Anonymous — Thu, 06 Mar 2014 09:53:33 GMT

Thanks a lot Sudeep.

Re: partial reload

IAMDV — Thu, 06 Mar 2014 10:16:08 GMT

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,

Re: partial reload

Anonymous — Thu, 06 Mar 2014 10:19:44 GMT

Thanks Deepak.Quite helpful videos.

Re: partial reload

IAMDV — Thu, 06 Mar 2014 10:21:34 GMT

I'm glad. Thanks for the feedback!

Re: partial reload

mudanhong — Thu, 04 Feb 2021 06:55:07 GMT

Thanks Colin. But I know partial load works in QLikView. how can it work in Qlik Sense Script?

Re: partial reload

mudanhong — Thu, 04 Feb 2021 06:56:43 GMT

Does it work in Qlik Sense?

And how can i set the IsPartialReload() to be true or false in Qlik Sense?