topic How to create an average line over 2 dimensions? in QlikView https://community.qlik.com/t5/QlikView/How-to-create-an-average-line-over-2-dimensions/m-p/768792#M273064 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';">Hi,</SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';"><BR /></SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';">I am trying to create an average score per QuestionType per student/ resident.&nbsp; However, whenever I put in one more expression (the average score), the chart legend changes which is not what I want.&nbsp; </SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';"><BR /></SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';">Below are the screenshot to explain:</SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';">The below chart is the chart I need to show, only lacking is an average of all the question types grouped by per resident.</SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';">Second screenshot shows that my QuestionType changed to score when I put in average line expression.&nbsp; </SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';">How should i put in my average line so that the chart will remain as if shown in screenshot 1.</SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';"><BR /></SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';">thanks!<BR /></SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';"><BR /></SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';"><IMG alt="Picture1.jpg" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/76273_Picture1.jpg" style="height: 278px; width: 620px;" /></SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';"><IMG alt="Picture2.jpg" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/76301_Picture2.jpg" style="height: 290px; width: 620px;" /><BR /></SPAN></P></BODY></HTML> Tue, 27 Jan 2015 02:35:08 GMT 2015-01-27T02:35:08Z How to create an average line over 2 dimensions? https://community.qlik.com/t5/QlikView/How-to-create-an-average-line-over-2-dimensions/m-p/768792#M273064 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';">Hi,</SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';"><BR /></SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';">I am trying to create an average score per QuestionType per student/ resident.&nbsp; However, whenever I put in one more expression (the average score), the chart legend changes which is not what I want.&nbsp; </SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';"><BR /></SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';">Below are the screenshot to explain:</SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';">The below chart is the chart I need to show, only lacking is an average of all the question types grouped by per resident.</SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';">Second screenshot shows that my QuestionType changed to score when I put in average line expression.&nbsp; </SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';">How should i put in my average line so that the chart will remain as if shown in screenshot 1.</SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';"><BR /></SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';">thanks!<BR /></SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';"><BR /></SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';"><IMG alt="Picture1.jpg" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/76273_Picture1.jpg" style="height: 278px; width: 620px;" /></SPAN></P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';"><IMG alt="Picture2.jpg" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/76301_Picture2.jpg" style="height: 290px; width: 620px;" /><BR /></SPAN></P></BODY></HTML> Tue, 27 Jan 2015 02:35:08 GMT https://community.qlik.com/t5/QlikView/How-to-create-an-average-line-over-2-dimensions/m-p/768792#M273064 2015-01-27T02:35:08Z