topic Re: Displaying top 10 by abs value in flat table in App Development https://community.qlik.com/t5/App-Development/Displaying-top-10-by-abs-value-in-flat-table/m-p/97226#M6497 <HTML><HEAD></HEAD><BODY><P>Did it work?</P></BODY></HTML> Fri, 02 Nov 2018 20:13:27 GMT dplr-rn 2018-11-02T20:13:27Z Displaying top 10 by abs value in flat table https://community.qlik.com/t5/App-Development/Displaying-top-10-by-abs-value-in-flat-table/m-p/97224#M6495 <HTML><HEAD></HEAD><BODY><P>Hey all,</P><P></P><P>We have an problem where we need to show the Top 10 values by absolute value, and have the rest grouped into others.</P><P></P><P>We have been using the chart Limitation option, and setting it to 11, but this shows only the biggest 10 positive values. I know that you can change the expression to use fabs() and it will give us the top 10, but we need the values to still show as negative in their formatting.</P><P></P><P>Any idea how we can accomplish this? Is there a way to put an expression in the Limitation Expression Editor that could accomplish this?</P></BODY></HTML> Wed, 31 Oct 2018 20:39:43 GMT https://community.qlik.com/t5/App-Development/Displaying-top-10-by-abs-value-in-flat-table/m-p/97224#M6495 elijahabel 2018-10-31T20:39:43Z Re: Displaying top 10 by abs value in flat table https://community.qlik.com/t5/App-Development/Displaying-top-10-by-abs-value-in-flat-table/m-p/97225#M6496 <HTML><HEAD></HEAD><BODY><P>Use Dual function where you set your display i.e. negative as the text and numerical as fabs.</P><P>See below</P><P>Dual(text(DummyValue),fabs(DummyValue))</P></BODY></HTML> Thu, 01 Nov 2018 16:47:00 GMT https://community.qlik.com/t5/App-Development/Displaying-top-10-by-abs-value-in-flat-table/m-p/97225#M6496 dplr-rn 2018-11-01T16:47:00Z Re: Displaying top 10 by abs value in flat table https://community.qlik.com/t5/App-Development/Displaying-top-10-by-abs-value-in-flat-table/m-p/97226#M6497 <HTML><HEAD></HEAD><BODY><P>Did it work?</P></BODY></HTML> Fri, 02 Nov 2018 20:13:27 GMT https://community.qlik.com/t5/App-Development/Displaying-top-10-by-abs-value-in-flat-table/m-p/97226#M6497 dplr-rn 2018-11-02T20:13:27Z