topic Re: show -50 as (50) in QlikView

show -50 as (50)

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

Can any one please help me.

I have created one straight table their in expressions tab i wrote one expression like this

Sum({<year={2018}>}Sales) - Sum({<Year=(2017)}Sales) in Sales field their i got one negative value like -50.

Now i want to show this -50 as (50). Please help me to do this.

Re: show -50 as (50)

sunny_talwar — Mon, 07 Mar 2016 16:29:57 GMT

May be this:

Num(Sum({<year={2018}>}Sales) - Sum({<Year={2017}>}Sales), '#,##0;(#,##0)')

Re: show -50 as (50)

andrespa — Mon, 07 Mar 2016 16:55:53 GMT

Hi, maybe you can use this one:

Fabs(Sum({<year={2018}>}Sales) - Sum({<Year=(2017)}Sales))

Re: show -50 as (50)

engishfaque — Tue, 08 Mar 2016 04:05:51 GMT

Dear Bhavvi,

Enclose your expression with Fabs() function, here is the way

=Fabs(Sum({<year={2018}>}Sales) - Sum({<Year=(2017)}Sales))

Kind regards,

Ishfaque Ahmed

Re: show -50 as (50)

HirisH_V7 — Tue, 08 Mar 2016 04:46:18 GMT

Hi,

Check this,

From this,

LOAD * INLINE [
    Sales, Customer
    50, A
    -50, B
];

In the table expression,

If(Num(Sales)='##0',Sales,Num(Sales,'##0;(##0)'))

HTH,

Hirish

Re: show -50 as (50)

jonathandienst — Tue, 08 Mar 2016 04:58:01 GMT

SunnyT's answer is correct, but you can also achieve that format in the chart properties Number tab. Select "Fixed" Enter the same format string #,##0;(#,##0) (match to your preferred thousands format and check it in the preview box.

Re: show -50 as (50)

avinashelite — Tue, 08 Mar 2016 05:22:34 GMT

you can also try like this

'('&fabs(Sum({<year={2018}>}Sales) - Sum({<Year=(2017)}Sales) )&')'

Re: show -50 as (50)

Chanty4u — Mon, 14 Mar 2016 12:02:32 GMT

chk dis

Formating: Using fabs() and num() functions in text object