topic conditional statement loading script in QlikView

conditional statement loading script

Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

Here is my question, how to set conditional statement in loading script?

I would like to load new data when [Field1] = 0, reload/remain existing data when [Field1] =1.

I am using the following scripts:

Load [Field1],

...

From ...

Exit script when [Field1] = 1

But there is problem, when exit script, no data will be loaded, so all charts and tables are empty, no data to display.

Please help, thank you.

Regards,

Lee

Thu, 19 Jan 2017 01:37:12 GMT

My another tryout:

but no working very well.

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

If [Field1] = 0 then

data:

load ....

from ....

store data into \QVD\data.qvd(qvd);

else

data:

load ....

from \QVD\data.qvd(qvd);

end if

drop table data;

qlikviewwizard — Thu, 19 Jan 2017 02:02:30 GMT

Hi,

Try like this:

Create a vField1 Variable and assign.

IF vField1 = '0' THEN

Data:

Load *

From QVD;

Endif;