Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

Sort of positiv and negativ values

Hi,

i have a Problem regarding to a sorting of positiv and negativ values. My Dimension is 'Name' and the field where i like to sort the values is called 'VALUES'. This field values includes for example -1000, 25000, -256, 5000 etc.

What i want is a sort of the highest varitations of the vaules from the 0 Point. For example

Name/Value

A/1000

B/500

c/5

D/-10000

E/-80000

F/9000

G/12000

The requirement is to sort the top 3 varitations. In this case is the solution is ...

1. E / -80000

2. G / 12000

3: D / -10000

In the moment i am sorting of the field VALUE with numeric value desc. But this don´t give me my solution which i Need.

Thanks...

3 Replies

Re: Sort of positiv and negativ values

In the sort tab use Fabs(Value), with this instruction you evaluate absolute value.

let me  know

Not applicable

Re: Sort of positiv and negativ values

Hi Thomas,

use the fabs() function, this will give you absolute value, returning a positive.

You can either use this in your script and create a new field to sort on (or load name as a dual with the number element based on the fabs).

Or in the front end, sort using the an expression based on the fabs result.

hope that helps

Joe

Re: Sort of positiv and negativ values

Is this what you want? PFA

Best,

S