topic Need help in creating a filter in QlikView https://community.qlik.com/t5/QlikView/Need-help-in-creating-a-filter/m-p/447442#M166948 <HTML><HEAD></HEAD><BODY><P>Hello Guru's,</P><P></P><P>I need your help in creating a filter Stages, the first two are working fine, the third condtion is not working.</P><P></P><P> If(Status= 1,4, 5 and Code &lt;&gt; ' '), 'In Process',</P><P></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; If(Status=9,7,3 and Number&lt;&gt;1),'Process Completed',</P><P></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If(Number &lt;&gt; 1, 'Total of All Process')&nbsp; as Stages </P><P></P><P>Could you please somebody help me ...</P><P></P><P>Regards</P><P></P><P>Chriss</P></BODY></HTML> Fri, 12 Apr 2013 07:00:53 GMT 2013-04-12T07:00:53Z Need help in creating a filter https://community.qlik.com/t5/QlikView/Need-help-in-creating-a-filter/m-p/447442#M166948 <HTML><HEAD></HEAD><BODY><P>Hello Guru's,</P><P></P><P>I need your help in creating a filter Stages, the first two are working fine, the third condtion is not working.</P><P></P><P> If(Status= 1,4, 5 and Code &lt;&gt; ' '), 'In Process',</P><P></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; If(Status=9,7,3 and Number&lt;&gt;1),'Process Completed',</P><P></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If(Number &lt;&gt; 1, 'Total of All Process')&nbsp; as Stages </P><P></P><P>Could you please somebody help me ...</P><P></P><P>Regards</P><P></P><P>Chriss</P></BODY></HTML> Fri, 12 Apr 2013 07:00:53 GMT https://community.qlik.com/t5/QlikView/Need-help-in-creating-a-filter/m-p/447442#M166948 2013-04-12T07:00:53Z