topic Re: GetCurrentField in QlikView https://community.qlik.com/t5/QlikView/GetCurrentField/m-p/537121#M200747 <HTML><HEAD></HEAD><BODY><P>Sorted out...</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.727272033691406px;">Avg(Aggr(SUM(InvoiceValue)</SPAN>,$(=GetCurrentField(Selection))))</P></BODY></HTML> Mon, 20 Jan 2014 13:44:57 GMT MK_QSL 2014-01-20T13:44:57Z GetCurrentField https://community.qlik.com/t5/QlikView/GetCurrentField/m-p/537120#M200746 <HTML><HEAD></HEAD><BODY><P>I have cyclic group named Selection with below dimensions...</P><P>CustomerName</P><P>Item</P><P>Brand</P><P></P><P>Want to use this cyclic group in bar chart for with there is a reference line showing average sales.</P><P></P><P>What is wrong in below? It's simply not working !</P><P></P><P>Avg(Aggr(SUM(InvoiceValue),GetCurrentField(Selection)))</P></BODY></HTML> Mon, 20 Jan 2014 13:40:19 GMT https://community.qlik.com/t5/QlikView/GetCurrentField/m-p/537120#M200746 MK_QSL 2014-01-20T13:40:19Z Re: GetCurrentField https://community.qlik.com/t5/QlikView/GetCurrentField/m-p/537121#M200747 <HTML><HEAD></HEAD><BODY><P>Sorted out...</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.727272033691406px;">Avg(Aggr(SUM(InvoiceValue)</SPAN>,$(=GetCurrentField(Selection))))</P></BODY></HTML> Mon, 20 Jan 2014 13:44:57 GMT https://community.qlik.com/t5/QlikView/GetCurrentField/m-p/537121#M200747 MK_QSL 2014-01-20T13:44:57Z