topic Re: If variable is equal to 'POS' then... in QlikView

If variable is equal to 'POS' then...

sibrulotte — Wed, 01 Jul 2015 20:49:53 GMT

Hi,

I thought this would be straight foreward:

IF $(POS_vs_TRANS) = 'POS' THEN

Addon:

replace LOAD * INLINE [

Addon

];

ELSE

TRACE $(POS_vs_TRANS);

end if

;

I'm tracing in the else just to check if my variable has the correct value, and it does... but I never load that table...

Re: If variable is equal to 'POS' then...

maxgro — Wed, 01 Jul 2015 22:20:22 GMT

try

IF '$(POS_vs_TRANS)' = 'POS' THEN

....

ELSE

....

ENDIF;

Re: If variable is equal to 'POS' then...

sunny_talwar — Wed, 01 Jul 2015 22:38:28 GMT

I am guessing (because you have Replace next to LOAD) that you are doing a partial reload to load this table because Replace LOAD won't be reloaded during a regular reload.

Re: If variable is equal to 'POS' then...

svenkita — Thu, 02 Jul 2015 05:42:57 GMT

IF '$(POS_vs_TRANS)' = 'POS' THEN
Addon:
replace LOAD * INLINE [
Addon
1
2
3
];
ELSE
TRACE $(POS_vs_TRANS);
end if;