topic How to sum quantities with negative value in a bar corde chart? in QlikView https://community.qlik.com/t5/QlikView/How-to-sum-quantities-with-negative-value-in-a-bar-corde-chart/m-p/144948#M23753 <HTML><HEAD></HEAD><BODY><P>ok please find the attachements.</P><P>-Sathish</P></BODY></HTML> Tue, 26 May 2009 00:32:01 GMT sathishkumar_go 2009-05-26T00:32:01Z How to sum quantities with negative value in a bar corde chart? https://community.qlik.com/t5/QlikView/How-to-sum-quantities-with-negative-value-in-a-bar-corde-chart/m-p/144943#M23748 <HTML><HEAD></HEAD><BODY><P>I have a barcorde chart that shows net sales by customer, dividing by group of products. But in this month for an especific customer, he had a devolution and in the chart shows a value of -55 for a group and 626 for the other group. All other customers shows the sum of the quantities over the data, but I don't know why when a negative value appears, the sum is not showed in the right way, and it is causing a confusion for my user. Anyone can help me with that?</P></BODY></HTML> Mon, 25 May 2009 19:47:25 GMT https://community.qlik.com/t5/QlikView/How-to-sum-quantities-with-negative-value-in-a-bar-corde-chart/m-p/144943#M23748 rcandeo 2009-05-25T19:47:25Z How to sum quantities with negative value in a bar corde chart? https://community.qlik.com/t5/QlikView/How-to-sum-quantities-with-negative-value-in-a-bar-corde-chart/m-p/144944#M23749 <HTML><HEAD></HEAD><BODY><P>Hi, Robson</P><P>Do you use a Section Access in your document? I can't oprn it</P><P></P></BODY></HTML> Mon, 25 May 2009 20:04:27 GMT https://community.qlik.com/t5/QlikView/How-to-sum-quantities-with-negative-value-in-a-bar-corde-chart/m-p/144944#M23749 sparur 2009-05-25T20:04:27Z How to sum quantities with negative value in a bar corde chart? https://community.qlik.com/t5/QlikView/How-to-sum-quantities-with-negative-value-in-a-bar-corde-chart/m-p/144945#M23750 <HTML><HEAD></HEAD><BODY><P>Sorry, I had took it out, but forgot to reload it. Try to open this one please.</P><P>Robson</P></BODY></HTML> Mon, 25 May 2009 20:10:59 GMT https://community.qlik.com/t5/QlikView/How-to-sum-quantities-with-negative-value-in-a-bar-corde-chart/m-p/144945#M23750 rcandeo 2009-05-25T20:10:59Z How to sum quantities with negative value in a bar corde chart? https://community.qlik.com/t5/QlikView/How-to-sum-quantities-with-negative-value-in-a-bar-corde-chart/m-p/144946#M23751 <HTML><HEAD></HEAD><BODY><P>Hi Robson,</P><P>According to ur application that negative value is correct. based on ur expression it comes -55. Check this application</P></BODY></HTML> Mon, 25 May 2009 22:43:56 GMT https://community.qlik.com/t5/QlikView/How-to-sum-quantities-with-negative-value-in-a-bar-corde-chart/m-p/144946#M23751 sathishkumar_go 2009-05-25T22:43:56Z How to sum quantities with negative value in a bar corde chart? https://community.qlik.com/t5/QlikView/How-to-sum-quantities-with-negative-value-in-a-bar-corde-chart/m-p/144947#M23752 <HTML><HEAD></HEAD><BODY><P>Yes, it is correct. But I don't wanna see - 55. I wanna see the sum of both groups - 626 - 55=571</P></BODY></HTML> Mon, 25 May 2009 23:12:47 GMT https://community.qlik.com/t5/QlikView/How-to-sum-quantities-with-negative-value-in-a-bar-corde-chart/m-p/144947#M23752 rcandeo 2009-05-25T23:12:47Z How to sum quantities with negative value in a bar corde chart? https://community.qlik.com/t5/QlikView/How-to-sum-quantities-with-negative-value-in-a-bar-corde-chart/m-p/144948#M23753 <HTML><HEAD></HEAD><BODY><P>ok please find the attachements.</P><P>-Sathish</P></BODY></HTML> Tue, 26 May 2009 00:32:01 GMT https://community.qlik.com/t5/QlikView/How-to-sum-quantities-with-negative-value-in-a-bar-corde-chart/m-p/144948#M23753 sathishkumar_go 2009-05-26T00:32:01Z How to sum quantities with negative value in a bar corde chart? https://community.qlik.com/t5/QlikView/How-to-sum-quantities-with-negative-value-in-a-bar-corde-chart/m-p/144949#M23754 <HTML><HEAD></HEAD><BODY><P>But you changed my chart. I wanna find out, why in my situation, it is showing me the negative number, instead of the total of the groups.</P><P>Robson</P></BODY></HTML> Tue, 26 May 2009 01:53:23 GMT https://community.qlik.com/t5/QlikView/How-to-sum-quantities-with-negative-value-in-a-bar-corde-chart/m-p/144949#M23754 rcandeo 2009-05-26T01:53:23Z How to sum quantities with negative value in a bar corde chart? https://community.qlik.com/t5/QlikView/How-to-sum-quantities-with-negative-value-in-a-bar-corde-chart/m-p/144950#M23755 <HTML><HEAD></HEAD><BODY><P>Robson,</P><P></P><P>It very well might be a bug or an "undocumented feature". In those cases, you typically do 2 things - report it as a bug to QlikTech and look for a work around to get your job done despite the problem.</P><P>Oleg</P></BODY></HTML> Tue, 26 May 2009 03:55:02 GMT https://community.qlik.com/t5/QlikView/How-to-sum-quantities-with-negative-value-in-a-bar-corde-chart/m-p/144950#M23755 Oleg_Troyansky 2009-05-26T03:55:02Z How to sum quantities with negative value in a bar corde chart? https://community.qlik.com/t5/QlikView/How-to-sum-quantities-with-negative-value-in-a-bar-corde-chart/m-p/144951#M23756 <HTML><HEAD></HEAD><BODY><P>Hi Robson,</P><P>Oleg is correct in this case. This is a bug with the following bug ID#: 21159. I'm not sure how to best work around the issue at the moment unfortunately. This is listed as a high severity bug so hopefully it will be fixed before long.</P></BODY></HTML> Tue, 26 May 2009 20:17:41 GMT https://community.qlik.com/t5/QlikView/How-to-sum-quantities-with-negative-value-in-a-bar-corde-chart/m-p/144951#M23756 Anonymous 2009-05-26T20:17:41Z