topic Re: Condition limit in if() condition in QlikView https://community.qlik.com/t5/QlikView/Condition-limit-in-if-condition/m-p/1366359#M832977 <HTML><HEAD></HEAD><BODY><P>As Sunny Suggested You can use Pick(match) as Replacement for Multiple IF's</P><P>Best Practice is to shift this calculation in load script by creating Flag and Use this Flag in front end</P></BODY></HTML> Wed, 14 Jun 2017 08:46:07 GMT passionate 2017-06-14T08:46:07Z Condition limit in if() condition https://community.qlik.com/t5/QlikView/Condition-limit-in-if-condition/m-p/1366355#M832973 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>Is there any limit to the number of OR conditions that can be used inside the IF() condition?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Condition-limit-in-if-condition/m-p/1366355#M832973 Anonymous 2020-11-25T16:16:04Z Re: Condition limit in if() condition https://community.qlik.com/t5/QlikView/Condition-limit-in-if-condition/m-p/1366356#M832974 <HTML><HEAD></HEAD><BODY><P>No Limit ...</P><P></P><P>But it is causes on performance better to create variable and put if condition in variable ...</P></BODY></HTML> Wed, 14 Jun 2017 08:00:48 GMT https://community.qlik.com/t5/QlikView/Condition-limit-in-if-condition/m-p/1366356#M832974 prma7799 2017-06-14T08:00:48Z Re: Condition limit in if() condition https://community.qlik.com/t5/QlikView/Condition-limit-in-if-condition/m-p/1366357#M832975 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P><SPAN style="font-size: 13.3333px;">I Think there's some limit there, can you share your logic or </SPAN>qvw file. so that we can able to check and help on that. Thanks</P><P></P><P>Regards,<BR />Deva</P></BODY></HTML> Wed, 14 Jun 2017 08:06:30 GMT https://community.qlik.com/t5/QlikView/Condition-limit-in-if-condition/m-p/1366357#M832975 devarasu07 2017-06-14T08:06:30Z Re: Condition limit in if() condition https://community.qlik.com/t5/QlikView/Condition-limit-in-if-condition/m-p/1366358#M832976 <HTML><HEAD></HEAD><BODY><P>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)</P></BODY></HTML> Wed, 14 Jun 2017 08:09:23 GMT https://community.qlik.com/t5/QlikView/Condition-limit-in-if-condition/m-p/1366358#M832976 sunny_talwar 2017-06-14T08:09:23Z Re: Condition limit in if() condition https://community.qlik.com/t5/QlikView/Condition-limit-in-if-condition/m-p/1366359#M832977 <HTML><HEAD></HEAD><BODY><P>As Sunny Suggested You can use Pick(match) as Replacement for Multiple IF's</P><P>Best Practice is to shift this calculation in load script by creating Flag and Use this Flag in front end</P></BODY></HTML> Wed, 14 Jun 2017 08:46:07 GMT https://community.qlik.com/t5/QlikView/Condition-limit-in-if-condition/m-p/1366359#M832977 passionate 2017-06-14T08:46:07Z Re: Condition limit in if() condition https://community.qlik.com/t5/QlikView/Condition-limit-in-if-condition/m-p/1366360#M832978 <HTML><HEAD></HEAD><BODY><P>Thank you all for your assistance.</P></BODY></HTML> Wed, 14 Jun 2017 09:54:01 GMT https://community.qlik.com/t5/QlikView/Condition-limit-in-if-condition/m-p/1366360#M832978 Anonymous 2017-06-14T09:54:01Z