topic Re: How to show negative values in bar chart in QlikView

How to show negative values in bar chart

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

Hi,

We have a bar chart and my requirement is i need to show all the values(positive and negative) in Y axis and on the same direction.

So i used these code in the expression to get the chart

=fabs(sum ({$<dim={'abc'}>}xxx)) - converting negative values with absolute values. Please see the screen shot attached, and distinguishing negative values with red color and positive value with green color.

Now i need to show the '-' sign if the value is negative however the chart bar should be on the y axis same direction as it is .

so my requirement is to display the '-' if it is negative. Is there way to do it.

Re: How to show negative values in bar chart

jonathandienst — Fri, 07 Jun 2019 05:12:10 GMT

To display a - sign for the negatives while keepin the absolue value, use a dual:

=Dual(sum ({$<dim={'abc'}>}xxx), fabs(sum ({$<dim={'abc'}>}xxx)))

To set the colours, exapnd the background property of the expressions (click the + next to the expression on the expressions tab). Use the expression:

If(sum ({$<dim={'abc'}>}xxx) < 0, red(), green())

(Adjust your colours to taste)

Re: How to show negative values in bar chart

ashis — Fri, 07 Jun 2019 05:22:40 GMT

Hi John, Thank you for the quick reply. I changed the formula as you suggested.

=Dual(sum ({$<dim={'abc'}>}xxx), fabs(sum ({$<dim={'abc'}>}xxx)))

Seems like it did not do anything. I also tried #,##0#,-##0 in number tab .

Did now work .

Re: How to show negative values in bar chart

ashis — Fri, 07 Jun 2019 06:44:45 GMT

I also try this in expression

=num(Dual(sum ({$<dim={'abc'}>}xxx), fabs(sum ({$<dim={'abc'}>}xxx))),'#,##0','-#,##0') and then in number made it expression default. But did not workout.

Any thought.

Thank you,

Re: How to show negative values in bar chart

Vegar — Fri, 07 Jun 2019 07:06:50 GMT

The solution presented by @jonathandienst should work.

Please see my attached qvw.

Re: How to show negative values in bar chart

ashis — Fri, 07 Jun 2019 07:16:47 GMT

Hi Vegar,

Thank you for your reply. Yes i see your qvw is working fine. Some how mine is not. Not sure where is the problem though.

Re: How to show negative values in bar chart

Vegar — Fri, 07 Jun 2019 09:13:49 GMT

Maybe you could post a limited sample where the problem is still valid?

Re: How to show negative values in bar chart

jonathandienst — Mon, 10 Jun 2019 05:57:07 GMT

The expressions I posted explained the pattern for the expression - they will not work like that, you need to fill out the expression details which you did not supply in your original post.

Re: How to show negative values in bar chart

ashis — Mon, 10 Jun 2019 09:21:36 GMT

Hi Jontydpki,

Thank you for your reply. My original expression is

=fabs(sum ({$<L3={'ATTRIB'}>}Sales))

Please let me know if you need more info. Thank you again.

Kind regards,

Ashis Sau

Re: How to show negative values in bar chart

Vegar — Mon, 10 Jun 2019 10:36:14 GMT

Please see attached new version of my demo app.

Re: How to show negative values in bar chart

ashis — Mon, 10 Jun 2019 10:51:03 GMT

Thank you Vegar, for your time. You also gave me one qvw file earlier that was working fine.

I believe something weird happening at my end. I am unable to send my application due to some restriction of data.

I will look into it why it is causing the issue. The solution seems simple though.

Thank you very much.