topic Re: Different between If ... then and When in QlikView

Different between If ... then and When

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Can anyone tell me what is the difference between the following scripts:

Suppose we have a variable called "A" and is set to = 1;

If A = 1 then

load * inline{

Col A, Col B,

1,2,

3,4

];

end if;

---------------------

When A := 1

load * inline{

Col A, Col B,

1,2,

3,4

];

Would second query be fired automatically if the value of variable "A" changed to something other than 1 and than change back to 1?

Thanks!

Re: Different between If ... then and When

Gysbert_Wassenaar — Mon, 07 Nov 2016 11:38:20 GMT

An if statement can have an else branch, a when statement doesn't. With a When there's only one block of code that will or will not be executed. In an If-then-else you can have two alternative blocks of code. See the online help: When

Re: Different between If ... then and When

its_anandrjs — Mon, 07 Nov 2016 12:12:09 GMT

In first code the table is run and loaded while in the second code it will not run as Gysbert suggest you have to use When with nested if statement.

Regards

Anand