Bar Offset in stacked Bar Chart

[#1]

I need to lift stacked bar in bar chart. But this chart behaves strangly when there is a negative values.

Hire is the examle file. Any idea how to do this?

[#2]

Any ideas?

[#3]

Hi Alexey,

I'm facing the same problem, please let me know if you have got a solution for this.

Thanks in advance

[#4]

There is no solution. It's impossible to correctly lift stacked bar chart if it contains positive and negative values.

At least in current versions of QlikView.

[kaushiknsolanki]

Hi,

     I guess you are facing issue cause you have kept 2 dimensions for the bar chart.

     Remove the field A from dimension and add one more expression as Sum(A) then i guess stacked bar works properly even for negative values.

Regards,

Kaushik Solanki

[#6]

This is the example app, in actual application dimension "a" is a product.

[#7]

Hi Kaushik,

Thanks for the input, but if I remove a dimension from the chart & put it into expression, it's no longer a stacked chart.

Is there any other work around?

Regards,

Pawan

[kaushalview]

Hi,

In bar chart if your value is Negtive then its showing chart as above the axis.

As per Qlikview Functionality it is correct. So there is no Solution for your application.

Regards

Kaushal Mehta

[#9]

I came to the same conclusion.