topic Re: Load where and if in QlikView

Load where and if

Anonymous — Wed, 11 Oct 2017 09:21:17 GMT

Hi all,

I want to restrict my load with a variable.

Example:

Test:

Load

resident Pretest

where Zahl < 5000 // here I want to use a variable that where is olny active if variable = 1

Thank you for helping

Robert

Re: Load where and if

tresB — Wed, 11 Oct 2017 09:25:50 GMT

Try like :

where $(variableName) = 1;

you may use it in combination as well like:

where Zahl < 5000 and $(variableName) = 1;

Re: Load where and if

Chanty4u — Wed, 11 Oct 2017 09:27:37 GMT

try this

1. don't set the variable in the script to an empy value (let Myvar = '';)

2. use right notation in Where Clause:

WHERE (Field1 = $(Myvar)); // on numeric value

WHERE (Field1 = '$(Myvar)'); // on string value

or simply

WHERE '$(vtest)'=1;

Re: Load where and if

Kushal_Chawda — Wed, 11 Oct 2017 09:28:52 GMT

if variable =1 then

Let vCondition ='where Zahl < 5000';

else

Let vCondition ='';

Endif

Test:

Load

resident Pretest

$(vCondition);

Re: Load where and if

Anonymous — Wed, 11 Oct 2017 09:46:51 GMT

Thank you.

It works if $(variableName) = 1

but if $(variableName) = 0 there is no load => I want to load everything if $(variableName) = 0

Re: Load where and if

tresB — Wed, 11 Oct 2017 09:50:45 GMT

In that case, I guess the example kush141087‌ explained below should work. Try that.

Re: Load where and if

Anonymous — Wed, 11 Oct 2017 09:52:33 GMT

Thank you very much => sureshqv

Re: Load where and if

Chanty4u — Wed, 11 Oct 2017 09:56:17 GMT

Thanks it works for you

Re: Load where and if

parthesh — Wed, 11 Oct 2017 09:58:52 GMT

Hello,

Please try below.

Example:

Test:

Load

resident Pretest

where If($(vLoadValue)=1, Zahl < 5000) ;

Re: Load where and if

Anonymous — Thu, 12 Oct 2017 08:37:41 GMT

Hi parthesh raval,

doesn't work for $(vLoadValue)=0