Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Partial Reload failed in a script with variables

Hi!,

I 'm trying to make a partial reload of  the following script:

PRODUCCION_TIMELINE:

Replace LOAD

codigoOP_PO as codigoOP_POPL,

maquina_PO as maquina_PO_POPL,

fechaInicioReal_PO as fechaInicioReal,

fechaFinReal_PO as fechaFinReal,

item_PO as item_PO_POPL,

codigoOP_PO &'-'& item_PO as CodigoItem,

if($(VariableDesde)>fechaInicioReal_PO and $(VariableDesde)<fechaFinReal_PO and fechaFinReal_PO<$(VariableHasta),$(VariableDesde),

if($(VariableDesde)<fechaInicioReal_PO and $(VariableHasta)>fechaFinReal_PO,date(fechaInicioReal_PO,'YYYY/MM/DD hh:mm:ss'),

if($(VariableDesde)<fechaInicioReal_PO and $(VariableHasta)<fechaFinReal_PO and $(VariableHasta)>fechaInicioReal_PO,date(fechaInicioReal_PO,'YYYY/MM/DD hh:mm:ss'),

if($(VariableDesde)>fechaInicioReal_PO and $(VariableDesde)<fechaFinReal_PO and $(VariableHasta)<fechaFinReal_PO,$(VariableDesde),'0')))) as fechaInicioVirtual,

 

if($(VariableDesde)>fechaInicioReal_PO and $(VariableDesde)<fechaFinReal_PO and fechaFinReal_PO<$(VariableHasta),date(fechaFinReal_PO,'YYYY/MM/DD hh:mm:ss'),

if($(VariableDesde)<fechaInicioReal_PO and $(VariableHasta)>fechaFinReal_PO,date(fechaFinReal_PO,'YYYY/MM/DD hh:mm:ss'),

if($(VariableDesde)<fechaInicioReal_PO and $(VariableHasta)<fechaFinReal_PO and $(VariableHasta)>fechaInicioReal_PO,$(VariableHasta),

if($(VariableDesde)>fechaInicioReal_PO and $(VariableDesde)<fechaFinReal_PO and $(VariableHasta)<fechaFinReal_PO,$(VariableHasta),'0')))) as fechaFinVirtual

 

resident PRODUCCION

where (($(VariableDesde)>fechaInicioReal_PO and $(VariableDesde)<fechaFinReal_PO and $(VariableHasta)>fechaFinReal_PO) OR

($(VariableDesde)<fechaInicioReal_PO and $(VariableHasta)>fechaFinReal_PO) OR

($(VariableDesde)<fechaInicioReal_PO and $(VariableHasta)<fechaFinReal_PO and $(VariableHasta)>fechaInicioReal_PO) OR

($(VariableDesde)>fechaInicioReal_PO and $(VariableDesde)<fechaFinReal_PO and $(VariableHasta)<fechaFinReal_PO));

where ' VariableDesde ' and VariableHasta 'are two date  variables selected in the front end .
The idea is  create a new table from ' PRODUCCION  ' filtering between two dates, but can not get it to work.
I tried it with ' REPLACE ' ' ADD ' ' REPLACE ONLY ' ' ADD ONLY ' but still does not work .

Any idea to fix it?

Thanks.

2 Replies
vlad_komarov
Partner - Specialist III
Partner - Specialist III

It's hard to suggest without seeing the full script (specifically the part where your variables are defined), but try to add single quotes to your variables in the script:

$(VariableDesde)  --> '$(VariableDesde)'


And what kind of error you are receiving during the load?


Regards,

Vlad

Not applicable
Author

Hi Vlad,

The variables are created and assigned a value from an extension ' Calendar Date Picker ' as follows :

qlik.currApp().variable.create('VariableDesde');

qlik.currApp(t).variable.setContent( 'VariableDesde' , valFromAux);

To perform partial load I use an extension ' Qlik -Sense -Reload - Button' , the only error I receive is ' Partial Reload Failed' .
I looked at the logs and  I get the following error: ' General Script Error '

With the total reload it works.
Thank you