topic Re: Load only a part of script in QlikView

Load only a part of script

Wed, 04 Dec 2013 16:20:16 GMT

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

Re: Load only a part of script

bbi_mba_76 — Wed, 04 Dec 2013 16:32:18 GMT

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.

Re: Load only a part of script

Wed, 04 Dec 2013 16:39:49 GMT

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

Re: Load only a part of script

christian77 — Wed, 04 Dec 2013 17:05:47 GMT

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.

Re: Load only a part of script

Thu, 05 Dec 2013 13:42:22 GMT

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

Re: Load only a part of script

christian77 — Thu, 05 Dec 2013 15:20:10 GMT

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.

Re: Load only a part of script

Fri, 06 Dec 2013 10:41:30 GMT

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