topic Re: Average in graph in QlikView https://community.qlik.com/t5/QlikView/Average-in-graph/m-p/327886#M120746 <HTML><HEAD></HEAD><BODY><P>This?&nbsp; "Total" tells it to ignore your dimension values.</P><P></P><P style="padding-left: 30px;"><SPAN style="font-family: courier new,courier;">12*sum(total [CM Tickets])/sum(total Population)</SPAN></P></BODY></HTML> Wed, 25 May 2011 23:17:36 GMT johnw 2011-05-25T23:17:36Z Average in graph https://community.qlik.com/t5/QlikView/Average-in-graph/m-p/327885#M120745 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am trying to show the avergae Incident Rate in the column for the Qlikview attached. I have worked out the incident rate and I know that the average is 3.01, I want this showing in the right hand column.</P><P></P><P>The trendline function will not suffice here as I need to use the average for some other calcuations. Please help???</P><P></P><P>Dave</P></BODY></HTML> Wed, 25 May 2011 15:37:32 GMT https://community.qlik.com/t5/QlikView/Average-in-graph/m-p/327885#M120745 2011-05-25T15:37:32Z Re: Average in graph https://community.qlik.com/t5/QlikView/Average-in-graph/m-p/327886#M120746 <HTML><HEAD></HEAD><BODY><P>This?&nbsp; "Total" tells it to ignore your dimension values.</P><P></P><P style="padding-left: 30px;"><SPAN style="font-family: courier new,courier;">12*sum(total [CM Tickets])/sum(total Population)</SPAN></P></BODY></HTML> Wed, 25 May 2011 23:17:36 GMT https://community.qlik.com/t5/QlikView/Average-in-graph/m-p/327886#M120746 johnw 2011-05-25T23:17:36Z Re: Average in graph https://community.qlik.com/t5/QlikView/Average-in-graph/m-p/327887#M120747 <HTML><HEAD></HEAD><BODY><P> John,</P><P></P><P>Had to tweak it slightly but works a treat. This total function will enable me to do a few reports</P></BODY></HTML> Thu, 26 May 2011 09:12:30 GMT https://community.qlik.com/t5/QlikView/Average-in-graph/m-p/327887#M120747 2011-05-26T09:12:30Z