Partial Reload

kostiskampouris — Wed, 25 Nov 2020 16:16:04 GMT

Hello everybody!

I have a qlikview document where there are many script tabs and I created a new one.I want to make a partial reload for only the last tab which I have added.

To achieve that and after of searching and reading in comunity I wrote

mytable:

REPLACE

Sql select * from

where AttikaDate= '$(vReloadDate)';

This seems to work but the problem is some variables that call a stored procedure in previous tabs.This is the only part of the script that partial reload doesnt jump.

The 4 variables are

Let sellCur = 'execute procedure ' & $(CurrentSeason) & ',1,' & chr(39) & Date(today(),'YYYYMMDD') & chr(39);

Let sellPrv = 'execute procedure ' & $(PreviousSeason) & ',0,' & chr(39) & Date(today(),'YYYYMMDD') & chr(39);

Let sellCurLY = 'execute procedure ' & $(CurrentSeasonLY) & ',0,' & chr(39) & date(addmonths(today(),-12), 'YYYYMMDD') & chr(39);

Let sellPrvLY = 'execute procedure ' & $(PreviousSeasonLY) & ', 0,' & chr(39) & date(addmonths(today(),-12), 'YYYYMMDD') & chr(39);

How can I overcome this issue ?

Note that I am not the one who created the original document and I can't really tell for sure what the previous tabs do.

Thank you in advance

Re: Partial Reload

Anil_Babu_Samineni — Thu, 15 Feb 2018 14:17:49 GMT

Add and Replace are Qlik functionalities. Can you try this?

mytable:

ADD/REPLACE

Load * From table where AttikaDate= '$(vReloadDate)';

Sql select * from

where AttikaDate= '$(vReloadDate)';

Re: Partial Reload

settu_periasamy — Thu, 15 Feb 2018 14:20:04 GMT

May be you can skip this variable using the below script

If IsPartialReload() = 0 then

Variables;

END IF

Re: Partial Reload

kostiskampouris — Thu, 15 Feb 2018 14:28:45 GMT

Works Perfect!Thank you very much !!!

topic Re: Partial Reload in QlikView

Partial Reload

Re: Partial Reload

Re: Partial Reload

Re: Partial Reload