topic Variable to condition file table selection in QlikView

Variable to condition file table selection

Fri, 07 Oct 2011 17:35:46 GMT

Hi All,

I have an application that needs to condition which table(s) to load based on the content of a control table.

I loaded the control table and set a variable true/false.

If the variable is true, TABLEA is loaded.

If the variable is false, TABLEB is loaded and TABLEC is left joined to TABLEB.

The syntax escapes me. Can someone please point me in the right direction?

Thanks,

Rich

Fri, 07 Oct 2011 17:47:24 GMT

numeric value of True is -1, False is 0. You may check for these in an IF and LOAD A or B.

Fri, 07 Oct 2011 18:24:13 GMT

Thanks, for your reply Jasleen,

I found the syntax I was looking for;

IF '$(vEPDM)' = 1 then
Item:
Load ITNBR;
SQL Select ITNBR
FROM S10AE37C.AMFLIB7.ITEMASA;

Elseif '$(vEPDM)' = 0 then
Item:
TEMPB:
Load ITNBR;
SQL Select ITNBR
FROM S10AE37C.AMFLIB7.ITMRVA;

Endif