Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

conditional statement loading script

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

2 Replies
Not applicable
Author

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
Master II
Master II

Hi,

Try like this:

Create a vField1 Variable and assign.

IF vField1 = '0'  THEN

Data:

Load *

From QVD;

Endif;