topic Script line Error: end if in QlikView

Script line Error: end if

Tue, 24 Jan 2012 11:17:30 GMT

Can someone tell me what is wrong with my report?

Please find the attached error.

Anta

Script line Error: end if

vijay_iitkgp — Tue, 24 Jan 2012 11:32:00 GMT

Hi,

I think you are using loop on some if condition. Please see if you have end your if condition.

Script line Error: end if

Miguel_Angel_Baeyens — Tue, 24 Jan 2012 11:33:20 GMT

Well,

Not having the script is kind of mission impossible to say where the problem is. But according to the error shown it seems that there is a line containing "end if" that either is not closing a previous opening IF or it appears when it shouldn't do (for example, within a LOAD statement).

Hope that helps.

Miguel

Re: Script line Error: end if

Fri, 22 Aug 2014 08:36:23 GMT

Hi,

check if you have an simicolon ";" after you ENDIF statement. If yes. Delete it. It is not necessary and will throw the shown error.

Regards.

Sabine

Re: Script line Error: end if

Fri, 22 Aug 2014 12:26:20 GMT

Please post script.

Re: Script line Error: end if

Tue, 03 Feb 2015 09:34:53 GMT

Hi,

I had similar problem.

I found that, in case of statement If …. End If, QV checks the syntax after Exit script;

But it shows error only in one case - when using Dollar-Sign Expansion.

Check following code:

CASE 1

EXIT Script;

if $(NoVariable) = 1 then

end if

Then You get:

CASE 2

EXIT Script;

if NoVariable= 1 then

end if

No error message.

Check also what happens when you put these if … endif before Exit Script;

Hope it helps

Sebastian

(I use QV11 sr6)

Re: Script line Error: end if

Tue, 03 Feb 2015 09:56:57 GMT

Hi,

Please share the qvw.

Regards

$@M

Re: Script line Error: end if

klaus_kapero — Tue, 24 Feb 2015 12:27:13 GMT

Hello,

I had the same Problem. I fixed the Problem:

Behind !! the "Exit script" sheet I had some "bad coding" which was red underlined.

After Setting the "bad coding" in // Comment Lines the script run's without Errors.

It seems that QlikView checks the complete script coding - also after the Exit script;

Best regards

Klaus

Re: Script line Error: end if

georges_galvan — Tue, 14 Apr 2015 10:35:28 GMT

Hi,

I had a similar issue, and I fixed this as you say, by removing the dollars $ in the condition after the IF.

It seems that the $ are not nécessary.

I can confirm that Qlikview check the whole script in spite of the EXIT SCRIPT instruction.

Your fix has permited to me to stop loosing my time in this crazy bug.

Thanks you very much!

Georges