Negative value issue in bar chart.

[apthansh]

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]

some thing like this ?

[rahulpawarb]

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]

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]

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]

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