topic Top Values in QlikView

Top Values

ashokraju — Fri, 18 Aug 2017 06:25:44 GMT

Hi,

How to show top 10 values without regarding to its sign.

For Ex: I have 3 values 1000,2000,-3000. So I want to show -3000 as top value irrespective of sign.

Anil_Babu_Samineni — Fri, 18 Aug 2017 06:28:52 GMT

Either you can use Fabs() to change sign. Or you may explain how -3000 value will come into Top?

rahulpawarb — Fri, 18 Aug 2017 06:31:03 GMT

As a workaround, add an expression in sort by Expression option (Descending):

fabs(Value)

Regards!

Rahul Pawar

its_anandrjs — Fri, 18 Aug 2017 06:31:33 GMT

Hi,

First remove -ive sign from value and then find max number with using FABS() function here.

Ex:-

Tab:

Load *,Fabs(Values) as NewVals

Load * Inline

[

Values

1000

2000

-3000

];

Regards

Anand