topic Re: Filter out only rows with difference (calculated) in QlikView https://community.qlik.com/t5/QlikView/Filter-out-only-rows-with-difference-calculated/m-p/559988#M208989 <HTML><HEAD></HEAD><BODY><P>Thanks for a quick responce.</P><P></P><P>I am not sure where I could find "diminsianal limit" in my straight table ?</P><P></P><P>regards.</P></BODY></HTML> Mon, 02 Sep 2013 12:20:31 GMT 2013-09-02T12:20:31Z Filter out only rows with difference (calculated) https://community.qlik.com/t5/QlikView/Filter-out-only-rows-with-difference-calculated/m-p/559986#M208987 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have two columns with SET analysis which I compare. If there is any difference I set a name depending it its</P><P>lower or higher then the standard cost.</P><P></P><P>But I would like to remove all the rows which having 0 in the list only intreseted in the materials which differ.</P><P></P><P>regards mikael</P></BODY></HTML> Mon, 02 Sep 2013 12:06:46 GMT https://community.qlik.com/t5/QlikView/Filter-out-only-rows-with-difference-calculated/m-p/559986#M208987 2013-09-02T12:06:46Z Re: Filter out only rows with difference (calculated) https://community.qlik.com/t5/QlikView/Filter-out-only-rows-with-difference-calculated/m-p/559987#M208988 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can create a difference column in expression 1 and use fabs() function to have absolute values, hide this column in "Presentation", and use dimensional limit to filter only &gt; 0.</P></BODY></HTML> Mon, 02 Sep 2013 12:14:02 GMT https://community.qlik.com/t5/QlikView/Filter-out-only-rows-with-difference-calculated/m-p/559987#M208988 christophebrault 2013-09-02T12:14:02Z Re: Filter out only rows with difference (calculated) https://community.qlik.com/t5/QlikView/Filter-out-only-rows-with-difference-calculated/m-p/559988#M208989 <HTML><HEAD></HEAD><BODY><P>Thanks for a quick responce.</P><P></P><P>I am not sure where I could find "diminsianal limit" in my straight table ?</P><P></P><P>regards.</P></BODY></HTML> Mon, 02 Sep 2013 12:20:31 GMT https://community.qlik.com/t5/QlikView/Filter-out-only-rows-with-difference-calculated/m-p/559988#M208989 2013-09-02T12:20:31Z Re: Filter out only rows with difference (calculated) https://community.qlik.com/t5/QlikView/Filter-out-only-rows-with-difference-calculated/m-p/559989#M208990 <HTML><HEAD></HEAD><BODY><P>3rd tab in V11 </P></BODY></HTML> Mon, 02 Sep 2013 12:21:34 GMT https://community.qlik.com/t5/QlikView/Filter-out-only-rows-with-difference-calculated/m-p/559989#M208990 christophebrault 2013-09-02T12:21:34Z Re: Filter out only rows with difference (calculated) https://community.qlik.com/t5/QlikView/Filter-out-only-rows-with-difference-calculated/m-p/559990#M208991 <HTML><HEAD></HEAD><BODY><P>Thanks, I was in version 10 <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 02 Sep 2013 12:23:04 GMT https://community.qlik.com/t5/QlikView/Filter-out-only-rows-with-difference-calculated/m-p/559990#M208991 2013-09-02T12:23:04Z