topic Re: Display average based on a 2nd dimension in QlikView https://community.qlik.com/t5/QlikView/Display-average-based-on-a-2nd-dimension/m-p/700854#M252995 <HTML><HEAD></HEAD><BODY><P>Any ideas?</P></BODY></HTML> Wed, 20 Aug 2014 00:34:36 GMT 2014-08-20T00:34:36Z Display average based on a 2nd dimension https://community.qlik.com/t5/QlikView/Display-average-based-on-a-2nd-dimension/m-p/700853#M252994 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I've got a bar chart with "Transaction Type" as a dimension, and Amount as an expression. I need to add another expression (a line chart on the right axis) which calculates the average number of transactions by customer number per Transaction Type. This is the expression I'm using:</P><P></P><P>avg( aggr( Count([Transaction Type]), [Customer Number]))</P><P></P><P>However, the line starts off with a high value and stops halfway through the transaction types while increasing (which is wrong of course). When I click on a particular transaction type, the line (now a dot) displays the correct value. Any solutions please?</P><P></P><P></P><P>Also - a customer can have multiple transactions, but I'm not sure if QlikView will take that into account in the avg() expression or whether It needs to be specified?</P></BODY></HTML> Tue, 19 Aug 2014 07:26:17 GMT https://community.qlik.com/t5/QlikView/Display-average-based-on-a-2nd-dimension/m-p/700853#M252994 2014-08-19T07:26:17Z Re: Display average based on a 2nd dimension https://community.qlik.com/t5/QlikView/Display-average-based-on-a-2nd-dimension/m-p/700854#M252995 <HTML><HEAD></HEAD><BODY><P>Any ideas?</P></BODY></HTML> Wed, 20 Aug 2014 00:34:36 GMT https://community.qlik.com/t5/QlikView/Display-average-based-on-a-2nd-dimension/m-p/700854#M252995 2014-08-20T00:34:36Z