Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
massimilianoruf
Partner - Contributor III
Partner - Contributor III

Partial Reload and variables

Hi all,

is the "for each" statement skipped during Partial Reload?

Edit: the problem wasn't in the "for each" statement, it works correctly.

The problem is the initialization of the variable vClassi:

let vClassi = peek('classi');

Thanks,

Massimiliano.

19 Replies
massimilianoruf
Partner - Contributor III
Partner - Contributor III
Author

Hi,

the resident table exists and is the following:

CROSS_TMP:

Replace

LOAD [Classe valore],

     A1,

     A2,

     A3,

     B1,

     B2,

     C1,

     C2,

     D

FROM

$(DIRPROGETTOXLS)\SimulazioneLS.xls

(biff, embedded labels, table is [LivelliCross$]);

Thanks in advance,

Massimiliano.

richard_pearce6
Luminary Alumni
Luminary Alumni

Did you check the last value? can you share your data?

massimilianoruf
Partner - Contributor III
Partner - Contributor III
Author

The table is ok because the field "classi" is correct...

testPartial.PNG.png

Anonymous
Not applicable

Hi,

is the field classi unique in the datamodel? If not you should modify peek by peek('classi', -1, 'CLASSI_TABLE');

Best regards

Stefan

richard_pearce6
Luminary Alumni
Luminary Alumni

Ah I see you only have one row in the final table.

I've tested the data using a workbook to load the table and peeked the value no problem both on a partial and full reload. I would need to review your application as I can't replicate the fault.....

Rcihard

massimilianoruf
Partner - Contributor III
Partner - Contributor III
Author

The attachment is a simplified model that works in Full Reload but doesn't work in Partial Reload mode (variable vClassi emplty).

richard_pearce6
Luminary Alumni
Luminary Alumni


Hi,

Thanks for the file. I did a full load and checked the variable and then manually cleared the variable and did a partial reload, then leaving the variable did another partial reload.

For all three loads the variable was populated fine. When you say its empty are you checking the variable editor? (Sorry to ask the obvious)

Richard

massimilianoruf
Partner - Contributor III
Partner - Contributor III
Author

Yes, I did exactly the same procedure....

richard_pearce6
Luminary Alumni
Luminary Alumni

Hmmm, well I'm all out of ideas. Without being able to replicate the fault its difficult to fix.

The only final thing to suggest is changing the peek to the suggestion above including the name of the table and the row id. That doesn't make any difference in the example as it worked fine for me but you never know.

The other thing would be to test on another machine or perhaps even as extream as a fresh install (personal edition on a private PC) just to see if its not a QV issue.

Regards

Rcihard

massimilianoruf
Partner - Contributor III
Partner - Contributor III
Author

Thanks! Now it works!