Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
vijetas42
Specialist
Specialist

Presenting Numbers

Hi all ,

How to represent number in text box as it is means if calculation of my metric is coming in negative then negative else positive.

EX. total for one of my expression is coming as -9270 in grid but if same expression I am taking in textbox it's  coming as +ve value as 9270

Please suggest your opinions

Regard,

Vijeta

5 Replies
prma7799
Master III
Master III

Hi Vijeta,

Can post some sample data or explain bit more what you exactly want?

Thanks

PM

sushil353
Master II
Master II

Hi,

Test object will not change -ve values to positive.. there should something wrong with your expression..

Please share your expression or sample data for resolution.

HTH

Sushil

Not applicable

Hi,

expression result is in text-box returns exact result of an expression..please post your exp here for more idea..

PrashantSangle

Hi,

Use FABS()

fabs(YourExpression)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
ravindraa
Creator
Creator


Hi Vijeta Sharma,

  I hope you will get same value in text object which you get in charts , have you used fabs keyword in text object?

if you use fabs keyword you wont get negitive value.

can you send sample data and app it will help to solve that.

thanks

Ravindra