topic Re: Absolute Value Sort in Straight Table in QlikView

Absolute Value Sort in Straight Table

asknyldz — Wed, 25 Nov 2020 16:16:04 GMT

Hi there,

How can i Absolute Value Sort my values in Straight Table.

This is should be below,

2012 2000

2013 -1500

2011 1000

You can find attached sample file.

Re: Absolute Value Sort in Straight Table

swuehl — Mon, 17 Jul 2017 08:25:58 GMT

Have you tried a sort expression on sort tab:

=fabs( YourTableExpression )

Re: Absolute Value Sort in Straight Table

asknyldz — Mon, 17 Jul 2017 10:31:49 GMT

Dear Stefan,

Sorry i didn't success my original dashboard. You can find attached, maybe you can help with this.

Re: Absolute Value Sort in Straight Table

swuehl — Mon, 17 Jul 2017 12:07:04 GMT

You are using multiple dimensions, so only sorting one dimension would not return the desired result.

I've added a hidden dimension that is a combination of all used dimensions, i.e. a primary key to your table.

Not all your dimensional rows show results for both forecasted periods, that could also be a problem when sorting only on one expression. I've changed the sort expression to use your third column.

See attached.

Re: Absolute Value Sort in Straight Table

swuehl — Mon, 17 Jul 2017 12:22:00 GMT

It might be even possible and more simple to create another expression:

=Fabs("vs Last Forecast")

and use this expression to sort your table (column could also be hidden on presentation tab).

Re: Absolute Value Sort in Straight Table

asknyldz — Mon, 17 Jul 2017 12:32:13 GMT

Amazing!

Thanks