Conditional Table

[#1]

hi,

i have two Two table A,and B and a variable var

if var value is 1 then load the table A else load the table B

any suggestion on this???

[oknotsen]

Go to the Layout tab for each chart. On there you will find a Show option in the middle on the right-hand side. For table A set something like this in there:

var = 1

For table B something like this:

var <> 1

If you mean in your script, you could work with a CASE:

http://help.qlik.com/sense/2.1/en-US/online/#../Subsystems/Hub/Content/Scripting/ScriptControlStatem...

[sunny_talwar · Accepted solution]

May be something like this:

IF $(Var) = 1 then

     LOAD fieldNames

     FROM TableA;

ELSE

     LOAD fieldNames

     FROM TableB;

ENDIF

[Peter_Cammaert]

Or in your script:

IF var = 1 THEN

TableA:

LOAD * FROM TableSource (options);

ELSE

TableB:

LOAD * FROM OtherTableSource (options);

END IF

You can add an inputbox couple to var on a sheet to control the script code execution path.

Peter