Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
ashokraju
Contributor II
Contributor II

Top Values

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.

3 Replies
Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
rahulpawarb
Specialist III
Specialist III

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

fabs(Value)

Regards!

Rahul Pawar

its_anandrjs

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