Loop inside IFcondition - Qlik Community

shiveshsingh · ‎2017-05-24

Hi

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.

prieper · ‎2017-05-24

in the script: yes

IF Condition THEN

Loop1

ELSE

Loop2

END IF

Peter

Anil_Babu_Samineni · ‎2017-05-24

Why not, Something like below

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Peter_Cammaert · ‎2017-05-24

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.