Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load only a part of script

Dear All,

I have a scenario where I need to load only the part of script when button is clicked. For example with the below script

Characters:
Load Chr(RecNo()+Ord('A')-1) as Alpha, RecNo() as Num autogenerate 26;

ASCII:
Load
if(RecNo()>=65 and RecNo()<=90,RecNo()-64) as Num,
Chr(RecNo()) as AsciiAlpha,
RecNo() as AsciiNum
autogenerate 255
Where (RecNo()>=32 and RecNo()<=126) or RecNo()>=160 ;

I need to load only “ASCII” table when button is clicked not both tables

Thanks in advance and please do let me know in case of any clarification.

Regards

NR

6 Replies
bbi_mba_76
Partner - Specialist
Partner - Specialist

Hi,

maybe you could add a variable(set/reset by the same button) and then adding an if based on this variable in the script.

Not applicable
Author

Hi,

Thanks a lot for your quick response, can you please give me an example of if based load at the script level, Thanks

Regards

NR

christian77
Partner - Specialist
Partner - Specialist

Hi.

I don't think partial reload is alowed in Ajax view.

If is only for developing, set an add before the load statement and Qlik on Partial Reload.

Read the help about partial reload.

With a diferential reload as BBI_MBI sugests you are going to have to reload everything or everything plus that table.

Luck.

Not applicable
Author

Hi Christian,

Thanks for your mail, i tried using partial reload based on ADD and REPLACE, it worked fine in desktop version but the same did not worked in Ajax view.

So is it a bug or some settings we need to make at QEMC ?

Regards

NR

christian77
Partner - Specialist
Partner - Specialist

Hi.

It is not a bug. Refer to the manual about macros in Ajax.

Is the extra part to reload, always the same, or it changes depending on some parameter or variable?

In the first case, it's always the same part, you could do the next:

Load everything always and find some kind of restricion that does not allow the user to see that part until the button is Qlik.

Not applicable
Author

Hi Christian,

Thanks for your reply; I have referred to the macros in Ajax.

Extra part reloads changes based on variable and I am not able to load everything because it is a notes field and

if I load everything then the performance will be slow.

Regards

NR