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).

[avinashelite]

try with DUAL function , if part the expression would contain the - values and right part with positive values

[qlikviewwizard]

Hi Avinash, I tried but unable to achieve. Could you please tell me how?

[Chanty4u]

use  FABS(expression)

[jonathandienst]

A pie chart cannot display a mix of positive and negative numbers in any meaningful way. At best you will confuse your users, at worst, the results would be just plain wrong (such as using Fabs()).

Select an alternative visualisation such as a bar chart.

In general, to display -ve numbers in brackets, on the numbers tab, select Fixed (0 decimals) and enter the format pattern 0;(0)

[qlikviewwizard]

Hi Jonathan, 0;(0)  is not working. I am using dual(fabs(sum(sales)),fabs(sales))

[vikasmahajan]

you can use FABS function for the same.

Vikas

[manojkulkarni]

Please find attached

[jonathandienst]

I don't know what you are trying to do with the dual, but the dual function will ignore the format setting. If you format the plain expression sum(sales) using the format string I specified, you will get "20" for +20 and "(20)" for -20.

[Chanty4u]

FABS(Sum(Value))