Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

elijahabel
New Contributor III

Displaying top 10 by abs value in flat table

Hey all,

We have an problem where we need to show the Top 10 values by absolute value, and have the rest grouped into others.

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.

Any idea how we can accomplish this? Is there a way to put an expression in the Limitation Expression Editor that could accomplish this?

Tags (2)
2 Replies
Partner
Partner

Re: Displaying top 10 by abs value in flat table

Use Dual function where you set your display i.e. negative as the text and numerical as fabs.

See below

Dual(text(DummyValue),fabs(DummyValue))

Partner
Partner

Re: Displaying top 10 by abs value in flat table

Did it work?