topic Re: IF field = True THEN load script? in QlikView

IF field = True THEN load script?

greend21 — Wed, 25 Nov 2020 16:16:04 GMT

I want an to use an IF statement in my load script that checks if our database load is done before Qlik runs a loader. I have the SQL query check if the load is done and return true for [LoadComplete]. I then had my IF as IF(LoadComplete = 'True') THEN followed by my load script. LoadComplete can only have one value and it must be true or false. Any ideas on how I can get this to work? I also tried IF(Peek(LoadComplete) = 'True') THEN.

Re: IF field = True THEN load script?

swuehl — Wed, 05 Sep 2018 20:13:04 GMT

How does your script look like?

edit:

Maybe like this

// Script to load field LoadComplete into table Check

...

Let vCheck = Peek('LoadComplete',0,'Check');

TRACE $(vCheck);

IF vCheck = 'True' THEN

// other LOAD statements

ENDIF

Re: IF field = True THEN load script?

ahmar811 — Thu, 06 Sep 2018 11:31:20 GMT

try

Qlikview ScriptError variable also find below link for more details and examples.

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ErrorVariables/ScriptError.htm

Regards

Ahmar