Discussion Board for collaboration related to QlikView App Development.
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.
Either you can use Fabs() to change sign. Or you may explain how -3000 value will come into Top?
As a workaround, add an expression in sort by Expression option (Descending):
First remove -ive sign from value and then find max number with using FABS() function here.
Load *,Fabs(Values) as NewVals
Load * Inline