topic Charts: Sum Issue in QlikView https://community.qlik.com/t5/QlikView/Charts-Sum-Issue/m-p/461044#M1159036 <HTML><HEAD></HEAD><BODY><P>Hello ,</P><P>I'm creating a chart based on the belwo data:</P><P></P><P>Region&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Country&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Rev</P><P>NAM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; US&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>NAM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MEX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P>EMEA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6</P><P>EMEA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9</P><P></P><P></P><P>The issue is that when some body searches the data based on the country the chart is showing the Rev data for that country. For ex: if user searches for Country 'US' the chart shows Rev. number 10,&nbsp; whereas i alway want the chart to show data at Region Level, i.e it should show 15 for NAM.</P><P></P><P>How do i achieve this. My chart structure is </P><P></P><P>Region , Sum(Rev)</P><P>----------------------------</P><P></P><P>Thanks</P><P>P</P></BODY></HTML> Fri, 21 Dec 2012 19:18:45 GMT 2012-12-21T19:18:45Z Charts: Sum Issue https://community.qlik.com/t5/QlikView/Charts-Sum-Issue/m-p/461044#M1159036 <HTML><HEAD></HEAD><BODY><P>Hello ,</P><P>I'm creating a chart based on the belwo data:</P><P></P><P>Region&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Country&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Rev</P><P>NAM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; US&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>NAM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MEX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P>EMEA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6</P><P>EMEA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9</P><P></P><P></P><P>The issue is that when some body searches the data based on the country the chart is showing the Rev data for that country. For ex: if user searches for Country 'US' the chart shows Rev. number 10,&nbsp; whereas i alway want the chart to show data at Region Level, i.e it should show 15 for NAM.</P><P></P><P>How do i achieve this. My chart structure is </P><P></P><P>Region , Sum(Rev)</P><P>----------------------------</P><P></P><P>Thanks</P><P>P</P></BODY></HTML> Fri, 21 Dec 2012 19:18:45 GMT https://community.qlik.com/t5/QlikView/Charts-Sum-Issue/m-p/461044#M1159036 2012-12-21T19:18:45Z Re: Charts: Sum Issue https://community.qlik.com/t5/QlikView/Charts-Sum-Issue/m-p/461045#M1159037 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Try like this</P><P></P><P>=Sum({&lt;Country=&gt;} Rev)</P><P></P><P>it exclude the country selection</P></BODY></HTML> Fri, 21 Dec 2012 19:33:56 GMT https://community.qlik.com/t5/QlikView/Charts-Sum-Issue/m-p/461045#M1159037 MayilVahanan 2012-12-21T19:33:56Z