Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

Unable to sum up negative values

Hi,

I have a bar chart where i am unable to sum up negative values.

it sum up only positive values but not the negative values. can any one help?

Regards,

Gautham

9 Replies

Would you be able to share a sample?

Best,

Sunny

Creator
Creator

find the attachment, in straight table it is showing the correct sum but not in the bar chart.

Creator
Creator


is it a bug or i have to change the expression?  any one help

MVP
MVP

Alternate way to show sum is

expression

SUM(balance)

Remove Value on Data point from Expression Tab

Add one more expression, untick Bar and tick values on data point

SUM(Total <car> balance)

Specialist
Specialist

in your example you are saying that car c is showing 2000, it is correct. what are your expected values? for car c you have only one value which is 2000 so the sum will be 2000.

if you mean that for car b it is showing 2000 and -1000 and you want the sum to be 1000, then you need to remove the year dimension from the chart.

Add a second expression:  if(Column(1) > 0, sum(total <car> balance), '')

Then turn off "Values on Data Points" for the first expression

Turn on "Values on Data Points" and turn off "Bar" for the second expression

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Creator
Creator

Hi Jonathan,

thanks for the help, but in case of multiple expressions how to arrive the same. for example see the attached in this

Creator
Creator

for example in the attachment for car a it is showing 3000 instead of 1000

Creator
Creator

can any one help?