topic Report with negative values in QlikView

Report with negative values

Wed, 25 Nov 2020 16:16:04 GMT

Hi guys,

There is a report with negative values,it should be displayed in brackets.

for eg. -5 it should be displayed as (5).

How to achieve it ?

Thanks.

Anonymous — Fri, 05 Aug 2016 15:32:58 GMT

HI,

You can define a number format for it....

num(field,'##,#0;(##,#0)')

So defining the format in brackets after ; defines for negative values

krishnacbe — Fri, 05 Aug 2016 15:33:46 GMT

Try below expression

=if(Value<0 , '(' & fabs(Value) & ')',1)

Anonymous — Fri, 05 Aug 2016 15:46:51 GMT

Defining If statement with concatenating () with value will result in string values instead of numeric,

while if using num() , then it will return in numeric values only...