topic Re: Negative values in chart in QlikView

Negative values in chart

qlikviewwizard — Fri, 20 Nov 2020 18:02:30 GMT

Hi All,

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

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

Re: Negative values in chart

avinashelite — Mon, 16 Nov 2015 06:32:31 GMT

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

Re: Negative values in chart

qlikviewwizard — Mon, 16 Nov 2015 06:39:06 GMT

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

Re: Negative values in chart

Chanty4u — Mon, 16 Nov 2015 06:39:30 GMT

use FABS(expression)

Re: Negative values in chart

jonathandienst — Mon, 16 Nov 2015 06:41:31 GMT

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)

Re: Negative values in chart

qlikviewwizard — Mon, 16 Nov 2015 06:45:29 GMT

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

Re: Negative values in chart

vikasmahajan — Mon, 16 Nov 2015 06:45:55 GMT

you can use FABS function for the same.

Vikas

Re: Negative values in chart

manojkulkarni — Mon, 16 Nov 2015 06:47:13 GMT

Please find attached

Re: Negative values in chart

jonathandienst — Mon, 16 Nov 2015 06:50:00 GMT

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.

Re: Negative values in chart

Chanty4u — Mon, 16 Nov 2015 06:56:59 GMT

FABS(Sum(Value))

Re: Negative values in chart

Chanty4u — Mon, 16 Nov 2015 06:59:29 GMT

positive and negative values in pi chart.

Re: Negative values in chart

qlikviewwizard — Mon, 16 Nov 2015 06:59:37 GMT

Hi manojkulkarni ,

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

Re: Negative values in chart

jagan — Mon, 16 Nov 2015 08:03:41 GMT

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.

Re: Negative values in chart

manojkulkarni — Mon, 16 Nov 2015 08:39:40 GMT

Hi Arjun,

How did you solve this problem ? Please share the solution

Re: Negative values in chart

qlikviewwizard — Mon, 16 Nov 2015 09:05:50 GMT

Hi Manoj,

This is the celambarasansolution.

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

Re: Negative values in chart

manojkulkarni — Mon, 16 Nov 2015 09:22:52 GMT

Thanks Arjun.

Re: Negative values in chart

nagarjuna_kotha — Mon, 16 Nov 2015 09:28:25 GMT

PFA...