topic Re: Modify display value when sum<0 in QlikView

Modify display value when sum<0

razvan_brais — Wed, 25 Nov 2020 16:16:04 GMT

Hey guys. Me again. How can I modify the display of a value that is lower then 0;

I want that if the result is <0 to display it like this (value).

So if value is -150 to display (150)

Chanty4u — Thu, 29 Sep 2016 05:57:22 GMT

try

use Fabs function

Fabs(urexpression)

EX:

If(fabs(sum(sales)=0,Value)

sushil353 — Thu, 29 Sep 2016 06:00:43 GMT

Hi,

you can set the format like :

=num(sum(test),'#,##0.0;(#,##0.0)')

HTH

Sushil

razvan_brais — Thu, 29 Sep 2016 06:04:50 GMT

Do I have to write it in the text format of the expression , or it`s in the expression itself?

Anonymous — Thu, 29 Sep 2016 06:05:08 GMT

Just use Fabs(Fieldname) as script, it will treat all -ve values as +ve values

Anil_Babu_Samineni — Thu, 29 Sep 2016 06:07:51 GMT

Where you want to show this. I mean which object. If text object might be my solution is not work left all will work

Tri properties and them number tab choose

#.000; (#.000)

This format will give all positive number.

razvan_brais — Thu, 29 Sep 2016 06:25:29 GMT

Thank Anil , that worked.