Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Arjunarao
Honored Contributor II

Negative values in chart

Hi All,

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

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

Capture.PNG

1 Solution

Accepted Solutions
Chanty4u
Esteemed Contributor III

Re: Negative values in chart

16 Replies

Re: Negative values in chart

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

Arjunarao
Honored Contributor II

Re: Negative values in chart

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

Chanty4u
Esteemed Contributor III

Re: Negative values in chart

use  FABS(expression)

MVP
MVP

Re: Negative values in chart

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)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Arjunarao
Honored Contributor II

Re: Negative values in chart

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

vikasmahajan
Esteemed Contributor

Re: Negative values in chart

you can use FABS function for the same.

Vikas

Partner
Partner

Re: Negative values in chart

Please find attached

Highlighted
MVP
MVP

Re: Negative values in chart

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Chanty4u
Esteemed Contributor III

Re: Negative values in chart

FABS(Sum(Value))