Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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
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
Cool Happy Learning