topic Average in diagramme in QlikView https://community.qlik.com/t5/QlikView/Average-in-diagramme/m-p/893375#M655888 <HTML><HEAD></HEAD><BODY><P>Hi everyone!</P><P></P><P>What function allows add average over two variables.</P><P>I used:</P><P>Avg (VAR1 and VAR2).</P><P></P><P>It doesn't work properly.</P><P></P><P>Many thanks in advance!</P></BODY></HTML> Mon, 15 Jun 2015 13:15:32 GMT 2015-06-15T13:15:32Z Average in diagramme https://community.qlik.com/t5/QlikView/Average-in-diagramme/m-p/893375#M655888 <HTML><HEAD></HEAD><BODY><P>Hi everyone!</P><P></P><P>What function allows add average over two variables.</P><P>I used:</P><P>Avg (VAR1 and VAR2).</P><P></P><P>It doesn't work properly.</P><P></P><P>Many thanks in advance!</P></BODY></HTML> Mon, 15 Jun 2015 13:15:32 GMT https://community.qlik.com/t5/QlikView/Average-in-diagramme/m-p/893375#M655888 2015-06-15T13:15:32Z Re: Average in diagramme https://community.qlik.com/t5/QlikView/Average-in-diagramme/m-p/893376#M655889 <HTML><HEAD></HEAD><BODY><P>Try</P><P>=rangeAvg($(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">VAR1</SPAN>),$(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">VAR2</SPAN>))</P></BODY></HTML> Mon, 15 Jun 2015 14:01:48 GMT https://community.qlik.com/t5/QlikView/Average-in-diagramme/m-p/893376#M655889 santhoo_san 2015-06-15T14:01:48Z Re: Average in diagramme https://community.qlik.com/t5/QlikView/Average-in-diagramme/m-p/893377#M655890 <HTML><HEAD></HEAD><BODY><P>Unfortunately, it doesn't work</P></BODY></HTML> Mon, 15 Jun 2015 14:16:30 GMT https://community.qlik.com/t5/QlikView/Average-in-diagramme/m-p/893377#M655890 2015-06-15T14:16:30Z Re: Average in diagramme https://community.qlik.com/t5/QlikView/Average-in-diagramme/m-p/893378#M655892 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture3.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/89467_Capture3.JPG" style="height: auto;" />For me on my sample working, it works. Share a sample app. let us try.</P></BODY></HTML> Mon, 15 Jun 2015 14:19:36 GMT https://community.qlik.com/t5/QlikView/Average-in-diagramme/m-p/893378#M655892 santhoo_san 2015-06-15T14:19:36Z Re: Average in diagramme https://community.qlik.com/t5/QlikView/Average-in-diagramme/m-p/893379#M655893 <HTML><HEAD></HEAD><BODY><P>Santhosh,</P><P></P><P>Sorry for the question. Can I use this function in expressions (after upoading data)?&nbsp; When I use it in expression aberage over two fields is not estimated at all.</P></BODY></HTML> Mon, 15 Jun 2015 15:55:21 GMT https://community.qlik.com/t5/QlikView/Average-in-diagramme/m-p/893379#M655893 2015-06-15T15:55:21Z Re: Average in diagramme https://community.qlik.com/t5/QlikView/Average-in-diagramme/m-p/893380#M655896 <HTML><HEAD></HEAD><BODY><P>yes, you can use it. check if your variables are getting some values before averaging it.</P></BODY></HTML> Mon, 15 Jun 2015 16:14:50 GMT https://community.qlik.com/t5/QlikView/Average-in-diagramme/m-p/893380#M655896 santhoo_san 2015-06-15T16:14:50Z Re: Average in diagramme https://community.qlik.com/t5/QlikView/Average-in-diagramme/m-p/893381#M655898 <HTML><HEAD></HEAD><BODY><P>Yes, they get. I did it the same way as in your example. Average for separate fields are calculated, but average for two fields is not</P></BODY></HTML> Mon, 15 Jun 2015 16:18:17 GMT https://community.qlik.com/t5/QlikView/Average-in-diagramme/m-p/893381#M655898 2015-06-15T16:18:17Z