Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
apthansh
Creator
Creator

Negative value issue in bar chart.

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.

5 Replies
avinashelite

some thing like this ?

rahulpawarb
Specialist III
Specialist III

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
Creator
Creator
Author

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
Creator
Creator
Author

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
Not applicable

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