topic Re: Limit the results on Chart in QlikView https://community.qlik.com/t5/QlikView/Limit-the-results-on-Chart/m-p/562301#M209839 <HTML><HEAD></HEAD><BODY><P>Can i not have the&nbsp; other expressions still showing? As I kind of need to include these to the table as well?</P></BODY></HTML> Tue, 03 Sep 2013 08:08:02 GMT ivandrago 2013-09-03T08:08:02Z Limit the results on Chart https://community.qlik.com/t5/QlikView/Limit-the-results-on-Chart/m-p/562296#M209834 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>I have the attached Document, I only want to show data where the "New Qty" is less than the Old Qty".</P><P></P><P>So the prouctId "ABC2" should not appear? Is this possible by doing this on the chart and not through a script?</P><P></P><P>Thanks</P></BODY></HTML> Mon, 02 Sep 2013 18:53:47 GMT https://community.qlik.com/t5/QlikView/Limit-the-results-on-Chart/m-p/562296#M209834 ivandrago 2013-09-02T18:53:47Z Re: Limit the results on Chart https://community.qlik.com/t5/QlikView/Limit-the-results-on-Chart/m-p/562297#M209835 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>Remove the New and Old Expression and add the expression like this </P><P></P><P>=If((Sum([Qty_Old]) - sum(Qty)) &lt; 0,sum(Qty))</P><P></P><P>Regards,</P></BODY></HTML> Mon, 02 Sep 2013 19:13:26 GMT https://community.qlik.com/t5/QlikView/Limit-the-results-on-Chart/m-p/562297#M209835 v_iyyappan 2013-09-02T19:13:26Z Re: Limit the results on Chart https://community.qlik.com/t5/QlikView/Limit-the-results-on-Chart/m-p/562298#M209836 <HTML><HEAD></HEAD><BODY><P>Only one thing: </P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">If((Sum([Qty_Old]) - sum(Qty)) &gt; 0,sum(Qty))</SPAN></P><P></P><P>opposite signal!</P><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P></BODY></HTML> Mon, 02 Sep 2013 19:32:29 GMT https://community.qlik.com/t5/QlikView/Limit-the-results-on-Chart/m-p/562298#M209836 2013-09-02T19:32:29Z Re: Limit the results on Chart https://community.qlik.com/t5/QlikView/Limit-the-results-on-Chart/m-p/562299#M209837 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>PFA</P></BODY></HTML> Mon, 02 Sep 2013 20:16:41 GMT https://community.qlik.com/t5/QlikView/Limit-the-results-on-Chart/m-p/562299#M209837 MayilVahanan 2013-09-02T20:16:41Z Re: Limit the results on Chart https://community.qlik.com/t5/QlikView/Limit-the-results-on-Chart/m-p/562300#M209838 <HTML><HEAD></HEAD><BODY><P>Can i not have the&nbsp; other expressions still showing? As I kind of need to include these to the table as well?</P></BODY></HTML> Mon, 02 Sep 2013 20:17:40 GMT https://community.qlik.com/t5/QlikView/Limit-the-results-on-Chart/m-p/562300#M209838 ivandrago 2013-09-02T20:17:40Z Re: Limit the results on Chart https://community.qlik.com/t5/QlikView/Limit-the-results-on-Chart/m-p/562301#M209839 <HTML><HEAD></HEAD><BODY><P>Can i not have the&nbsp; other expressions still showing? As I kind of need to include these to the table as well?</P></BODY></HTML> Tue, 03 Sep 2013 08:08:02 GMT https://community.qlik.com/t5/QlikView/Limit-the-results-on-Chart/m-p/562301#M209839 ivandrago 2013-09-03T08:08:02Z Re: Limit the results on Chart https://community.qlik.com/t5/QlikView/Limit-the-results-on-Chart/m-p/562302#M209840 <HTML><HEAD></HEAD><BODY><P>Hi Ivan,</P><P></P><P></P><P>Please find the attached qvw. hope it will work.</P><P></P><P>Regards</P><P>Neetu Singh</P></BODY></HTML> Tue, 03 Sep 2013 10:19:58 GMT https://community.qlik.com/t5/QlikView/Limit-the-results-on-Chart/m-p/562302#M209840 neetu_singh 2013-09-03T10:19:58Z Re: Limit the results on Chart https://community.qlik.com/t5/QlikView/Limit-the-results-on-Chart/m-p/562303#M209841 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>PFA</P></BODY></HTML> Tue, 03 Sep 2013 12:19:08 GMT https://community.qlik.com/t5/QlikView/Limit-the-results-on-Chart/m-p/562303#M209841 MayilVahanan 2013-09-03T12:19:08Z