topic Re: Filter on expression. in QlikView https://community.qlik.com/t5/QlikView/Filter-on-expression/m-p/776519#M275279 <HTML><HEAD></HEAD><BODY><P>Can you post sample input and expected output</P></BODY></HTML> Tue, 13 Jan 2015 05:46:54 GMT anbu1984 2015-01-13T05:46:54Z Filter on expression. https://community.qlik.com/t5/QlikView/Filter-on-expression/m-p/776518#M275278 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm having store and style along with sales and units received in a straight table chart. I want to filter the rows where Sales and Units Received are equal at the store article level, can one of you help me in knowing how to achieve this?</P><P></P><P>Thanks</P><P>Venkatachalam.N</P></BODY></HTML> Mon, 12 Jan 2015 19:39:12 GMT https://community.qlik.com/t5/QlikView/Filter-on-expression/m-p/776518#M275278 2015-01-12T19:39:12Z Re: Filter on expression. https://community.qlik.com/t5/QlikView/Filter-on-expression/m-p/776519#M275279 <HTML><HEAD></HEAD><BODY><P>Can you post sample input and expected output</P></BODY></HTML> Tue, 13 Jan 2015 05:46:54 GMT https://community.qlik.com/t5/QlikView/Filter-on-expression/m-p/776519#M275279 anbu1984 2015-01-13T05:46:54Z Re: Filter on expression. https://community.qlik.com/t5/QlikView/Filter-on-expression/m-p/776520#M275280 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Look in the attached example let me know if this helps you</P><P></P><P>Thank</P><P>Priyal</P></BODY></HTML> Tue, 13 Jan 2015 06:15:11 GMT https://community.qlik.com/t5/QlikView/Filter-on-expression/m-p/776520#M275280 priyalshah9779 2015-01-13T06:15:11Z Re: Filter on expression. https://community.qlik.com/t5/QlikView/Filter-on-expression/m-p/776521#M275281 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">using </SPAN></P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Sales</SPAN><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #800000; font-size: 8pt;">Units</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #800000; font-size: 8pt;">Cat</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P><SPAN style="font-size: 8pt;">in a list box expression will serve the purpose.. if I have understood ur requirement.</SPAN></P><P></P><P></P><P><SPAN style="font-size: 8pt;">Regards,</SPAN></P><P><SPAN style="font-size: 8pt;">Dawar</SPAN></P></BODY></HTML> Tue, 13 Jan 2015 06:33:09 GMT https://community.qlik.com/t5/QlikView/Filter-on-expression/m-p/776521#M275281 2015-01-13T06:33:09Z