Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Condition limit in if() condition

Hello All,

Is there any limit to the number of OR conditions that can be used inside the IF() condition?

1 Solution

Accepted Solutions
passionate
Specialist
Specialist

As Sunny Suggested You can use Pick(match) as Replacement for Multiple IF's

Best Practice is to shift this calculation in load script by creating Flag and Use this Flag in front end

View solution in original post

5 Replies
prma7799
Master III
Master III

No Limit ...

But it is causes on performance better to create variable and put if condition in variable ...

devarasu07
Master II
Master II

Hi,

I Think there's some limit there, can you share your logic or qvw file. so that we can able to check and help on that. Thanks

Regards,
Deva

sunny_talwar

I have seen some old post suggesting that there might be a max condition of 100 ifs.... may be use Pick(Match()) to replace your if (if possible)

passionate
Specialist
Specialist

As Sunny Suggested You can use Pick(match) as Replacement for Multiple IF's

Best Practice is to shift this calculation in load script by creating Flag and Use this Flag in front end

Anonymous
Not applicable
Author

Thank you all for your assistance.