Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

apthansh
Contributor

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

Re: Negative value issue in bar chart.

some thing like this ?

rahulpawarb
Valued Contributor III

Re: Negative value issue in bar chart.

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
Contributor

Re: Negative value issue in bar chart.

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
Contributor

Re: Negative value issue in bar chart.

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.

laddu_927
Valued Contributor

Re: Negative value issue in bar chart.

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