Discussion Board for collaboration related to QlikView App Development.
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???
May be something like this:
IF $(Var) = 1 then
View solution in original post
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:
Or in your script:
IF var = 1 THEN
LOAD * FROM TableSource (options);
LOAD * FROM OtherTableSource (options);
You can add an inputbox couple to var on a sheet to control the script code execution path.