topic Re: Loop inside IFcondition in QlikView

Loop inside IFcondition

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

please confirm if we can make loops under If condition

If(Condition, Loop1 ,Loop2).

It would be good if you can explain with an example.

Re: Loop inside IFcondition

prieper — Wed, 24 May 2017 09:29:18 GMT

in the script: yes

IF Condition THEN

Loop1

ELSE

Loop2

END IF

Peter

Re: Loop inside IFcondition

Anil_Babu_Samineni — Wed, 24 May 2017 09:31:43 GMT

Why not, Something like below

If(Region = 'Andhra Pradesh', If(Sales > 30, 'Lowest Price', 'Highest Price'))

Re: Loop inside IFcondition

Peter_Cammaert — Wed, 24 May 2017 09:41:28 GMT

Actually, no. In QlikView script, there are two IFs: there is an IF() function that can be used in expressions, and there is an IF control statement that can be used in blocks of code. They look alike and may give you the impression that they do similar things. But they're to be used in different contexts.

An IF() function cannot contain loops (except if you consider the two-parameter SubField() function a "loop") because loops (like DO UNTIL/WHILE or FOR) are also control statements. And an IF (... THEN ... ELSE ... END IF) control statement can't be used inside expressions. That's how it is.

[Edit] The one in your OP is the function-version of course.