topic Conditional Formulas vs If In Formulas in QlikView https://community.qlik.com/t5/QlikView/Conditional-Formulas-vs-If-In-Formulas/m-p/1329362#M616999 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>As far as I know when you create expressions in a QV chart is better not to use <STRONG>if</STRONG><STRONG>()</STRONG> inside the functions, but what about use it in the definitions to choose between functions? Is it much worse than use the Conditional on the expression and then create various expressions?</P><P></P><P><IMG alt="TestCond1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/163014_TestCond1.png" style="height: auto;" /></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; or</P><P><IMG alt="Condition2.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/163015_Condition2.png" style="max-width: 620px; height: auto;" /></P><P></P><P>I think that int he first choice only tests the condition once per every time the expression has to be calculated. The second one tests it for every entry in a dimension. So, in case that i have a Time dimension Chart with 200 days the second one will calculate 200 times the if, and the fist just once, is it right?</P><P></P><P>Would happen the same if I use the <STRONG>pick()</STRONG> funcion?</P><P></P><P>Thank You in Advance</P><P></P><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 11 May 2017 15:27:35 GMT Anonymous 2017-05-11T15:27:35Z Conditional Formulas vs If In Formulas https://community.qlik.com/t5/QlikView/Conditional-Formulas-vs-If-In-Formulas/m-p/1329362#M616999 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>As far as I know when you create expressions in a QV chart is better not to use <STRONG>if</STRONG><STRONG>()</STRONG> inside the functions, but what about use it in the definitions to choose between functions? Is it much worse than use the Conditional on the expression and then create various expressions?</P><P></P><P><IMG alt="TestCond1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/163014_TestCond1.png" style="height: auto;" /></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; or</P><P><IMG alt="Condition2.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/163015_Condition2.png" style="max-width: 620px; height: auto;" /></P><P></P><P>I think that int he first choice only tests the condition once per every time the expression has to be calculated. The second one tests it for every entry in a dimension. So, in case that i have a Time dimension Chart with 200 days the second one will calculate 200 times the if, and the fist just once, is it right?</P><P></P><P>Would happen the same if I use the <STRONG>pick()</STRONG> funcion?</P><P></P><P>Thank You in Advance</P><P></P><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 11 May 2017 15:27:35 GMT https://community.qlik.com/t5/QlikView/Conditional-Formulas-vs-If-In-Formulas/m-p/1329362#M616999 Anonymous 2017-05-11T15:27:35Z