topic Re: Presenting Numbers in QlikView

Presenting Numbers

vijetas42 — Tue, 24 Mar 2015 05:16:02 GMT

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

prma7799 — Tue, 24 Mar 2015 05:22:13 GMT

Hi Vijeta,

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

Thanks

sushil353 — Tue, 24 Mar 2015 05:24:50 GMT

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

Tue, 24 Mar 2015 05:29:10 GMT

Hi,

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

PrashantSangle — Tue, 24 Mar 2015 05:30:59 GMT

Hi,

Use FABS()

fabs(YourExpression)

Regards

ravindraa — Tue, 24 Mar 2015 05:55:50 GMT

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