topic Re: How to set a button that only execute part of the script. in QlikView

How to set a button that only execute part of the script.

Thu, 10 Dec 2015 06:32:43 GMT

I have a Qlikview application witth two buttons A and B and a script similar to this:

// Part 1

Oracle_Table_1:

sql set * from Oracle_table;

store Oracle_table into c:\QlivewFile_1.qvd;

Oracle_Table_2:

sql set * from Oracle_table_2;

store Oracle_table into c:\QlivewFile_2.qvd;

// Part 2

Oracle_table_1_Final:

Load *

from c:\QlivewFile_1.qvd (qvd);

Oracle_table_2_Final:

Load *

from c:\QlivewFile_2.qvd (qvd);

Button A will execute both Part 1 and 2 in one go. This is fine and I can do this button.

But for button B, I only want to execute the Part 2 (i.e. Load from the qvd file). Could you give me some idea on how to do it?

Thanks in advance!

Re: How to set a button that only execute part of the script.

avinashelite — Thu, 10 Dec 2015 07:13:57 GMT

Try like this :

For the button A : add a action to set a variable like vA=1 and similarly for button B and in the load script you can utilize this variable to execute the load

Re: How to set a button that only execute part of the script.

avinashelite — Thu, 10 Dec 2015 07:18:18 GMT

try like this :

if $(vA)=1 then

// Part 1

Oracle_Table_1:

sql set * from Oracle_table;

store Oracle_table into c:\QlivewFile_1.qvd;

Oracle_Table_2:

sql set * from Oracle_table_2;

store Oracle_table into c:\QlivewFile_2.qvd;

ENDIF

if $(vB)=1 then

// Part 2

Oracle_table_1_Final:

Load *

from c:\QlivewFile_1.qvd (qvd);

Oracle_table_2_Final:

Load *

from c:\QlivewFile_2.qvd (qvd);

ENDIF

Re: How to set a button that only execute part of the script.

Thu, 10 Dec 2015 20:59:50 GMT

Avinashelite,

Thanks for your help!

It works now!

Re: How to set a button that only execute part of the script.

avinashelite — Fri, 11 Dec 2015 05:25:33 GMT

Cool Happy Learning