topic Re: Benchmarking Charts in QlikView https://community.qlik.com/t5/QlikView/Benchmarking-Charts/m-p/1153495#M912606 <HTML><HEAD></HEAD><BODY><P>May be using two expressions in a bar chart.</P><P></P><P>Dimension: <STRONG>Geography</STRONG></P><P></P><P>Expressions</P><P>1) C<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">ountry Average Sales -&gt; <STRONG>Avg({1}Aggr(Sum({1}Sales), Company))</STRONG></SPAN></P><P>2) Company's performance -&gt; <STRONG>Sum(Sales)</STRONG></P></BODY></HTML> Thu, 26 May 2016 17:34:37 GMT sunny_talwar 2016-05-26T17:34:37Z Benchmarking Charts https://community.qlik.com/t5/QlikView/Benchmarking-Charts/m-p/1153494#M912605 <HTML><HEAD></HEAD><BODY><P>Hi, new to this forum and trying to create a Benchmarking chart.</P><P></P><P>1. This would be in the form of a Bar Charts.</P><P>2. The Industry is selected and the company name is selected.</P><P>2. The output will be bar charts of the country Average Sales in a geography and next to it the company performance in that geography.</P><P></P><P>Please assist and guide in creating qvw's for this.</P><P></P><P>With regards,</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Benchmarking-Charts/m-p/1153494#M912605 2020-11-25T16:16:04Z Re: Benchmarking Charts https://community.qlik.com/t5/QlikView/Benchmarking-Charts/m-p/1153495#M912606 <HTML><HEAD></HEAD><BODY><P>May be using two expressions in a bar chart.</P><P></P><P>Dimension: <STRONG>Geography</STRONG></P><P></P><P>Expressions</P><P>1) C<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">ountry Average Sales -&gt; <STRONG>Avg({1}Aggr(Sum({1}Sales), Company))</STRONG></SPAN></P><P>2) Company's performance -&gt; <STRONG>Sum(Sales)</STRONG></P></BODY></HTML> Thu, 26 May 2016 17:34:37 GMT https://community.qlik.com/t5/QlikView/Benchmarking-Charts/m-p/1153495#M912606 sunny_talwar 2016-05-26T17:34:37Z