topic Re: Unable to sum up negative values in QlikView

Unable to sum up negative values

gauthamchilled — Wed, 22 Apr 2015 12:46:34 GMT

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

Re: Unable to sum up negative values

sunny_talwar — Wed, 22 Apr 2015 15:24:08 GMT

Would you be able to share a sample?

Best,

Sunny

Re: Unable to sum up negative values

gauthamchilled — Thu, 23 Apr 2015 05:54:42 GMT

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

Re: Unable to sum up negative values

gauthamchilled — Thu, 23 Apr 2015 06:39:07 GMT

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

Re: Unable to sum up negative values

MK_QSL — Thu, 23 Apr 2015 06:42:29 GMT

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)

Re: Unable to sum up negative values

maleksafa — Thu, 23 Apr 2015 06:43:59 GMT

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.

Re: Unable to sum up negative values

jonathandienst — Thu, 23 Apr 2015 06:53:07 GMT

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

Re: Unable to sum up negative values

gauthamchilled — Thu, 23 Apr 2015 07:44:37 GMT

Hi Jonathan,

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

Re: Unable to sum up negative values

gauthamchilled — Thu, 23 Apr 2015 08:00:37 GMT

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

Re: Unable to sum up negative values

gauthamchilled — Thu, 23 Apr 2015 08:55:48 GMT

can any one help?