topic Re: nested if then control statement in QlikView

nested if then control statement

Mon, 07 Jan 2013 16:57:59 GMT

Hello everyone,

I want to nest the if...then statement like

if ... then

do something

if... then

do something

endif

else

do something

endif

The problem is: there are two endifs and qlikview stops at the first one and doesn't go futher. Does anyone have a solution for this issue?

Many thanks in advance

Re: nested if then control statement

adamwilson — Mon, 07 Jan 2013 17:01:03 GMT

is the first endif needed?

if ... then

do something

if... then

do something

else

do something

endif

Re: nested if then control statement

nagaiank — Mon, 07 Jan 2013 17:06:35 GMT

Here is an extract from Qlikview Reference Manual. If you follow the syntax, it will work.

The syntax is:

if condition then

[ statements ]

{ elseif condition then

[ statements ] }

[ else

[ statements ] ]

end if

Where:

condition is a logical expression which can be evaluated as true or false.

statements is any group of one or more QlikView script statements.

Since the if..then statement is a control statement and as such is ended with either a semicolon or end-of-line,

each of its four possible clauses (if..then, elseif..then, else and end if) must not cross a line boundary.

Re: nested if then control statement

Mon, 07 Jan 2013 17:11:51 GMT

Yes, it is.

I actually have a elseif for the inner if...then, and qv stops by the elseif, so I remove it and qv stops by the first endif.

Re: nested if then control statement

Mon, 07 Jan 2013 17:17:12 GMT

'each of its four possible clauses (if..then, elseif..then, else and end if) must not cross a line boundary.'

Well I didn't, I wrote each of them just in a line.

Does it mean that I cann't use nested if...then statement in qv?

Re: nested if then control statement

Tue, 08 Jan 2013 08:51:19 GMT

Does anyone have any other ideas?

Thanks

Re: nested if then control statement

flipside — Tue, 08 Jan 2013 09:51:35 GMT

Are you wanting the "do something" after the else statement to execute and the script is only running the "if .. then" statement before it because if so that looks like it is working correctly. Perhaps post your actual script.

Re: nested if then control statement

Tue, 08 Jan 2013 15:13:21 GMT

The syntax seems to be correct for me. I really don't understand, why it doesn't work.Especially how can I let qv know that there are two if...then statements, they have nothing to do with each other.

Re: nested if then control statement

Wed, 09 Jan 2013 03:51:36 GMT

Here is an example of a nested If in Qlikview.

IF(Category = 'A',

IF(Country = 'AUS', 'Australia',

IF(Country = 'CHN' and Sub = 'HK', 'Hong Kong (SAR)'

, 'Unknown Asia Pacific'))

, IF(Category = 'B',

IF(Country = 'GER', 'Germany',

IF(Country = 'FRA', 'France'

, 'Unknown Europe'))

, 'Unknown'))

This is:

(

ElseIf

Else

)

ElseIf

(

ElseIf

Else

)

Else

Be careful of the commas, they trip you up when doing nested IF, it is best to follow a structure that you find comfortable and stick to it.

Re: nested if then control statement

flipside — Wed, 09 Jan 2013 09:09:11 GMT

Have you got multiple steps within your if statement, ensure they are terminated with semi-colons correctly.

If Day(Now())=1 or Day(Now())=2 or Day(Now())=3 then

LET vSuffix = '.qvd';

Store Profile into '..\Profile'$(vSuffix) (qvd);

Else

LET vSuffix = '.txt';

Store Profile into '..\Profile'$(vSuffix) (txt);

End If;

Other than that, please post your code.

flipside

Re: nested if then control statement

Wed, 09 Jan 2013 09:12:16 GMT

Thank you Sarcich, but this is not what I want, I mean more the IF...THEN...ENDIF Clause.

Re: nested if then control statement

Wed, 09 Jan 2013 10:08:25 GMT

For the syntax outside of the load statement it is just:

IF Criteria A THEN

IF Criteria 1 THEN

Set vSomeVariable = 'A1';

ELSEIF Criteria 2 THEN

Set vSomeVariable = 'A2';

ELSE

Set vSomeVariable = 'A#';

END IF

ELSEIF CriteriaB THEN

IF Criteria 1 THEN

Set vSomeVariable = 'B1';

ELSEIF Criteria 2 THEN

Set vSomeVariable = 'B2';

ELSE

Set vSomeVariable = 'B#';

END IF

ELSE

Set vSomeVariable = 'XX';

END IF

As flipside said, you have probably missed a semicolon or something like that.

Re: nested if then control statement

Thu, 10 Jan 2013 15:40:28 GMT

Do I have to use the complete clause? I tried with the following syntax:

IF Criteria A THEN

IF Criteria 1 THEN

Set vSomeVariable = 'A1';

ELSEIF Criteria 2 THEN

Set vSomeVariable = 'A2';

ELSE

END IF

ELSEIF CriteriaB THEN

IF Criteria I THEN

Set vSomeVariable = 'B1';

ELSEIF Criteria II THEN

Set vSomeVariable = 'B2';

ELSE

END IF

ELSE

END IF

I have only two criteria in each clause, so it's empty by else. The criteria A is not fulfilled, instead of comparing criteria B, it goes to criteria 2. I just don't understand why.

Re: nested if then control statement

flipside — Thu, 10 Jan 2013 22:10:48 GMT

That code works fine for me, could it be there is an error in Criteria A and it is actually evaluating to True?

Re: nested if then control statement

Tue, 15 Jan 2013 10:15:08 GMT

Hi filpside,

I tried the IF...Then statement with some simple code, it worked too. I think there must be some errors in the criteria or in the other code as you said.