Partial Reload

[kostiskampouris]

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

[Anil_Babu_Samineni]

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)';

[settu_periasamy · Accepted solution]

May be you can skip this variable using the below script

If IsPartialReload() = 0 then

Variables;

END IF

[kostiskampouris]

Works Perfect!Thank you very much !!!