Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
FLASH SALE: Save $500! Use code FLASH2026 at checkout until Feb 14th at 11:59PM ET. Register Now!
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

Labels (1)
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;