Why my partial reloading is not updating the values?

[brunolelli87]

Hello guys,

Could you please help me to identify why my partial reloading is not updating some values?

Basically, I'm using the partial reload to update the values of the following tables:

Variação
Ajustes
Cotação
Notícias
Taxas
Índices

The full reload is working perfectly, but the partial reloading is not updating the values.

Please, find my project attached;
Thanks 

[vamsee]

I don't see the else part in your script. I mean, at multiple instances you have added the if clause 

If '$(vExecMode)'='Full'

I didn't see

ElseIf '$(vExecMode)'='Partial'

[brunolelli87]

But I don't think we need the else part...
Based on what I understood, and please correct me if I'm wrong, every time you run a Partial reload, the system will load everything that has Replace or Add before the LOAD statement.

Running a partial Reload, I don't want to have the Tabs (Empresas, Bancos, Nomes...) updated, that's why I don't even insert the else statement.

The script was working perfectly until yesterday when I updated it with the following statement at the Cotações Tabrow

// início da sessão de teste

Replace
VarAnual:         
LOAD             
Null() as RowID,  
Null() as YDVP,  
Null() as STCK3,  
Null() as VDAF1,  
Null() as VDAF2  
autogenerate 0;

VarAnual:
Add Load 
RowNo() As RowID, 
YDVP, 
STCK3, 
FirstSortedValue(VDAF, DVPG) 	as VDAF1, 
FirstSortedValue(VDAF, -DVPG) 	as VDAF2
Resident Cotação Group By STCK3, YDVP
;

Replace
Variaçao:         
LOAD             
Null() as YDV2,  
Null() as STCK3,  
Null() as VVDAF  
autogenerate 0;  

Variaçao:
Add Load 
YDVP							as YDV2, 
STCK3							as STCK3, 
(VDAF2-VDAF1)/VDAF1 			as VVDAF
Resident VarAnual
;

Drop Table VarAnual;


// término da sessão de teste

Thanks for your help,
Bruno

[vamsee]

Yeah, you are right, I am sorry. I assumed you were triggering this using a button and variable, not the usual qlik way.

If you are sure that this script is causing you an error I would say running in a separate qvw and check if you are getting your desired output.

I also suggest you put some trace statements /debug in your script; to check the flow.