Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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