topic Re: Bar chart with negative numbers going up in QlikView

Bar chart with negative numbers going up

Tue, 08 Apr 2014 14:33:41 GMT

I have a chart where the numbers will always be negative, and the larger the negative number means a larger value. So, rather than having the x-axis displayed at the top of the chart with the bars going down I want the x-axis to be at the bottom with the negative values represented just like a positive number would be (with bars going up) yet the values listed vertically will still be negative numbers.

Is this a simple chart property I am missing?

Thanks

Re: Bar chart with negative numbers going up

MK_QSL — Tue, 08 Apr 2014 14:38:05 GMT

Create two same expression

Multiply first expression by -1 and select Bar in expression tab and deselect Values on data points

2nd expression without multiply by -1 and deselect Bar in expression tab and select values on data points.

Update : Check enclosed file..

Re: Bar chart with negative numbers going up

Roop — Tue, 08 Apr 2014 14:41:31 GMT

You could also format the numbers for the chart so that they had a "-" before them - They would not be negative but would alter their format.

Re: Bar chart with negative numbers going up

cfz — Tue, 08 Apr 2014 14:44:59 GMT

Hi Jessica,

The dual function can help you to easily obtain the desired result.

See attached example.

Kind regards

Carlos

Re: Bar chart with negative numbers going up

its_anandrjs — Tue, 08 Apr 2014 14:46:52 GMT

If want to show values always negative write your expression like

=Sum(sale) *-1

And

-Sum(sale)

But depends on the data on the fields according to that you have to use.

Regards

Re: Bar chart with negative numbers going up

maxgro — Tue, 08 Apr 2014 14:48:01 GMT

try with a dual expression

dual(num(sum(val), '#.##0'), sum(val)*-1)