topic Re: How can I do an if(and formula in a QlikView expression? in QlikView https://community.qlik.com/t5/QlikView/How-can-I-do-an-if-and-formula-in-a-QlikView-expression/m-p/804413#M471908 <HTML><HEAD></HEAD><BODY><P>Thanks, Mike.&nbsp; That worked.&nbsp; Not sure why I didn't think of trying that.&nbsp; Thanks again!</P></BODY></HTML> Mon, 23 Feb 2015 21:16:56 GMT rluciano1012 2015-02-23T21:16:56Z How can I do an if(and formula in a QlikView expression? https://community.qlik.com/t5/QlikView/How-can-I-do-an-if-and-formula-in-a-QlikView-expression/m-p/804411#M471906 <HTML><HEAD></HEAD><BODY><P>This is driving me crazy.&nbsp; I have an Excel formula that works perfectly in Excel but I can't figure out how write it in an expression to use in a straight table in QlikView.&nbsp; The IF statements work fine in the expression, but when I try to do AND, I just get errors.&nbsp; So I guess my question really is this. How can you do <SPAN style="color: #3366ff;">IF(AND</SPAN> functions in QlikView or something that does the same thing?</P><P></P><P>The gist of what I'm trying to do is restaurant menu engineering based on a recent menu mix of items sold.&nbsp; For example, <SPAN style="color: #3366ff;">IF</SPAN> a menu item is above average in popularity <SPAN style="color: #3366ff;">AND</SPAN> has an above average unit margin, then call the menu item a "Star", <SPAN style="color: #3366ff;">IF</SPAN> an item sells less than average units sold <SPAN style="color: #3366ff;">AND</SPAN> has a high unit margin, its a "Puzzle", <SPAN style="color: #3366ff;">IF</SPAN> an the item units sold are below average <SPAN style="color: #3366ff;">AND</SPAN> has below average unit margin, its a "Dog" and then if none of those are true, the formula would default to "Plowhorse", which would be a high seller but a lower than average unit margin.</P><P></P><P><SPAN style="font-size: 13.3333330154419px;">This is the EXCEL version of the formula.</SPAN></P><P></P><P>=<SPAN style="color: #3366ff;">IF(AND(</SPAN> UnitsSold &gt;= AvgUnitsSold, UnitMargin &gt;= AvgUnitMargin), "Star", <SPAN style="color: #3366ff;">IF(AND</SPAN><SPAN style="color: #3366ff;">(</SPAN> UnitsSold &lt;= AvgUnitsSold, UnitMargin &gt; AvgUnitMargin<SPAN style="color: #3366ff;">)</SPAN>, "Puzzle", <SPAN style="color: #3366ff;">IF(AND(</SPAN> UnitsSold &lt;= AvgUnitsSold, UnitMargin &lt; AvgUnitMargin<SPAN style="color: #3366ff;">)</SPAN>, "Dog", "Plowhorse"<SPAN style="color: #3366ff;">)))</SPAN></P><P></P><P>What would be an QlikView expression way to do that?&nbsp; All help is greatly appreciated!</P><P></P><P>Ross</P></BODY></HTML> Fri, 13 Feb 2015 17:09:42 GMT https://community.qlik.com/t5/QlikView/How-can-I-do-an-if-and-formula-in-a-QlikView-expression/m-p/804411#M471906 rluciano1012 2015-02-13T17:09:42Z Re: How can I do an if(and formula in a QlikView expression? https://community.qlik.com/t5/QlikView/How-can-I-do-an-if-and-formula-in-a-QlikView-expression/m-p/804412#M471907 <HTML><HEAD></HEAD><BODY><P>In place of:&nbsp;&nbsp; <SPAN style="color: #3366ff;">AND(</SPAN> UnitsSold &gt;= AvgUnitsSold, UnitMargin &gt;= AvgUnitMargin)</P><P>put&nbsp; UnitsSold &gt;= AvgUnitsSold AND&nbsp; UnitMargin &gt;= AvgUnitMargin</P></BODY></HTML> Fri, 13 Feb 2015 17:56:53 GMT https://community.qlik.com/t5/QlikView/How-can-I-do-an-if-and-formula-in-a-QlikView-expression/m-p/804412#M471907 m_woolf 2015-02-13T17:56:53Z Re: How can I do an if(and formula in a QlikView expression? https://community.qlik.com/t5/QlikView/How-can-I-do-an-if-and-formula-in-a-QlikView-expression/m-p/804413#M471908 <HTML><HEAD></HEAD><BODY><P>Thanks, Mike.&nbsp; That worked.&nbsp; Not sure why I didn't think of trying that.&nbsp; Thanks again!</P></BODY></HTML> Mon, 23 Feb 2015 21:16:56 GMT https://community.qlik.com/t5/QlikView/How-can-I-do-an-if-and-formula-in-a-QlikView-expression/m-p/804413#M471908 rluciano1012 2015-02-23T21:16:56Z