topic Re: how to load 2nd table without loading 1st table in QlikView

how to load 2nd table without loading 1st table

rjyadav94 — Sat, 05 Jan 2019 07:55:24 GMT

hi all,

can anyone please explain me how to reload the 2nd data from 2nd edit script window without reloading or commenting the 1st table data in 1st edit script window..??? is this possible or my questions is valid..

please reply me with good suggestion.

thanks and regards

Re: how to load 2nd table without loading 1st table

jonathandienst — Sat, 05 Jan 2019 08:19:20 GMT

There is no switch to simply disable one tab in the script editor (I think that is what you are asking).

You can change the tab order. To 'disable' a script tab, move it to the right after an Exit Script statement. I usually add an Exit tab that contains the Exit Script. Move the tab to be ignored to the right of the Ext tab.

Re: how to load 2nd table without loading 1st table

vanderson009 — Sat, 05 Jan 2019 13:49:45 GMT

Try using partial reload.

Re: how to load 2nd table without loading 1st table

swapniltaz — Mon, 07 Jan 2019 07:21:29 GMT

This Can be done in two ways :

Sol1:

a.Put the Second Edit script Window before the FIrst Table script by using Promote Tab

b. In the End of Second Script put Exit script command

Sol2:

Inside the FIrst Table SCript put a where condition 1=2

Re: how to load 2nd table without loading 1st table

rubenmarin — Mon, 07 Jan 2019 10:14:49 GMT

Another option can be enclosing all your 1st table script in a:
IF $(vFullReload)=1 THEN
//Script
ENDIF

Setting the variable vFullReload to 0 (or something different than 1) will skip that code, setting the variable to 1 will execute the code.

Re: how to load 2nd table without loading 1st table

rjyadav94 — Tue, 08 Jan 2019 05:12:51 GMT

so u mean to say i should write exit statement after writing the script in 2nd tab.? is that you want to say?

Re: how to load 2nd table without loading 1st table

rjyadav94 — Tue, 08 Jan 2019 05:13:20 GMT

ty for ur response but is is not working with partial reload ...

Re: how to load 2nd table without loading 1st table

rjyadav94 — Tue, 08 Jan 2019 05:16:22 GMT

thanks for your response..can you please give me the steps after creating the variable. should i create the buttons for this process? not getting eaxctly what you want to say?

Re: how to load 2nd table without loading 1st table

rubenmarin — Tue, 08 Jan 2019 11:06:48 GMT

Once you have your script ready to work checking the variable value there are different ways to change the variable value.

It can be a button in front-end, an inputbox, setting the variable value in variables overview panel or just a line of code in script or external file:

SET vFullReload =0; //Set to 1 to load all tables.

With buttons:

Add a new button, in actions tab add an action External->set variable to 0 or 1 and do another action external->Execute script.

You can have a button to load with 0, and another to load with 1.

Inputbox: just add a new inputbox control and add the variable. In rule you can edit the variable to preload values 0 and 1 to select.

Re: how to load 2nd table without loading 1st table

rjyadav94 — Thu, 10 Jan 2019 07:35:00 GMT

not getting solution 2.. why where condition and how to put that.. what is mean 1 and 2.