topic Re: Why my partial reloading is not updating the values? in QlikView

Why my partial reloading is not updating the values?

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

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

Re: Why my partial reloading is not updating the values?

vamsee — Mon, 01 Jun 2020 19:44:13 GMT

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'

Re: Why my partial reloading is not updating the values?

brunolelli87 — Mon, 01 Jun 2020 19:50:51 GMT

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

Re: Why my partial reloading is not updating the values?

vamsee — Mon, 01 Jun 2020 20:22:26 GMT

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.