topic If statement in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/If-statement/m-p/30571#M217 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Can you please help me in this problem</P><P></P><P>I need to have a KPI </P><P></P><P>Count({$&lt;[Turnover offered ( € )]&gt;}Account) this formula works </P><P></P><P>but i want to see the KIP only for the <SPAN style="font-size: 13.3333px;">[Turnover offered ( € )] that are more than 1€ (mean the formula should exclude 0&amp;1)</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P>Thank you in advance,</P><P></P><P>Sachin</P></BODY></HTML> Thu, 15 Feb 2018 11:40:29 GMT Anonymous 2018-02-15T11:40:29Z If statement https://community.qlik.com/t5/Connectivity-Data-Prep/If-statement/m-p/30571#M217 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Can you please help me in this problem</P><P></P><P>I need to have a KPI </P><P></P><P>Count({$&lt;[Turnover offered ( € )]&gt;}Account) this formula works </P><P></P><P>but i want to see the KIP only for the <SPAN style="font-size: 13.3333px;">[Turnover offered ( € )] that are more than 1€ (mean the formula should exclude 0&amp;1)</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P>Thank you in advance,</P><P></P><P>Sachin</P></BODY></HTML> Thu, 15 Feb 2018 11:40:29 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/If-statement/m-p/30571#M217 Anonymous 2018-02-15T11:40:29Z Re: If statement https://community.qlik.com/t5/Connectivity-Data-Prep/If-statement/m-p/30572#M218 <HTML><HEAD></HEAD><BODY><P>This should work:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Count({$&lt;[Turnover offered ( € )]={"&gt;1"} &gt;}Account) </SPAN></P></BODY></HTML> Thu, 15 Feb 2018 11:46:34 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/If-statement/m-p/30572#M218 dapostolopoylos 2018-02-15T11:46:34Z