topic Re: Negative value issue in bar chart. in QlikView

Negative value issue in bar chart.

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

Hi,

I have attached the QVW. When I do the sum it only display the sum of positive numbers and ignores the negative in the top.

Ex ABC - Instead of 500 , how can I show 200 at the top of bar chart.

Thank you.

avinashelite — Fri, 28 Apr 2017 04:15:15 GMT

some thing like this ?

rahulpawarb — Fri, 28 Apr 2017 04:27:58 GMT

Hello Ansh,

Trust that you are doing great!

As a work around we can fix this by following given steps:

1. Go to the dimension tab and keep on Address in Used Dimension list.

2. Remove existing expression and add below expressions;

//Rent
Sum({<Type={'Rent'}>}Amount) + Sum({<Type={'NonRent'}>}Amount)
//NonRent
Sum({<Type={'NonRent'}>}Amount)

Also refer the sample application attached herewith.

Regards!

Rahul

apthansh — Fri, 28 Apr 2017 12:49:49 GMT

I dont think I can do Rent + Non rent in frist expression as it show 200 for Rent when you hover over which is not correct.

Rent is 500

Non-Rent is -300

So total expense is 200 which should be on the top of the bar.

apthansh — Fri, 28 Apr 2017 12:52:03 GMT

Thank you.

I am looking for a stacked bar with Type as another dimension and when I add Type it doesn't add the negative number.

Anonymous — Fri, 28 Apr 2017 13:14:45 GMT

Am not sure if that possible, You have to choose another way of representing your data