Negative values in chart

[qlikviewwizard]

Hi All,

How to show negative values in brackets () in pie chart?

For ex: -53 as (53) and -111 as (111).

[Chanty4u · Accepted solution]

positive and negative values in pi chart.

[qlikviewwizard]

Hi manojkulkarni ,

Thanks for your advise. I need to show negative mouse over values in brackets.

[jagan]

Hi,

Check this link

How to create a pie chart with positive and negative values

OR try this expression

=dual(fabs(sum(sales)),Sum(sales))

Regards,

Jagan.

[manojkulkarni]

Hi Arjun,

How did you solve this problem ? Please share the solution

[qlikviewwizard]

Hi Manoj,

This is the celambarasansolution.

If(Sum(Sales)<0, Num(Fabs(Sum(Sales)), '(#,###'), Num(Sum(Sales), '#,###')

[manojkulkarni]

Thanks Arjun.

[nagarjuna_kotha]

PFA...