topic Creating Bar for Average of Two Fields in QlikView https://community.qlik.com/t5/QlikView/Creating-Bar-for-Average-of-Two-Fields/m-p/1432731#M613372 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I am working on survey data that have multiple entries. Survey data have multiple fields including 'Year' and 'Score'.&nbsp; I have calculated the year-wise average for the Score field that have values either 'Yes' or 'No' .</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">The requirement is to take an average for two years and labelled as '2014_2015_AVG' in the dimension (X-axis).&nbsp; I have provided a snap shot which may help in ease of understanding.</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"> Also, I wanted it to be shown as a separate bar in the middle of the chart.</SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Thank you<BR /></SPAN></P></BODY></HTML> Mon, 18 Sep 2017 12:54:34 GMT Anonymous 2017-09-18T12:54:34Z Creating Bar for Average of Two Fields https://community.qlik.com/t5/QlikView/Creating-Bar-for-Average-of-Two-Fields/m-p/1432731#M613372 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I am working on survey data that have multiple entries. Survey data have multiple fields including 'Year' and 'Score'.&nbsp; I have calculated the year-wise average for the Score field that have values either 'Yes' or 'No' .</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">The requirement is to take an average for two years and labelled as '2014_2015_AVG' in the dimension (X-axis).&nbsp; I have provided a snap shot which may help in ease of understanding.</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"> Also, I wanted it to be shown as a separate bar in the middle of the chart.</SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Thank you<BR /></SPAN></P></BODY></HTML> Mon, 18 Sep 2017 12:54:34 GMT https://community.qlik.com/t5/QlikView/Creating-Bar-for-Average-of-Two-Fields/m-p/1432731#M613372 Anonymous 2017-09-18T12:54:34Z