topic Re: set analysis expression in QlikView https://community.qlik.com/t5/QlikView/set-analysis-expression/m-p/1360785#M417113 <HTML><HEAD></HEAD><BODY><P>NOt sure what exactly? but think the TOTAL Keyword will work for you</P><P></P><P>AVG(&nbsp; TOTAL&nbsp; &lt;Country&gt;&nbsp;&nbsp;&nbsp;&nbsp; Sales)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;&lt;&nbsp; will give you total by each country ignoring other dimensions in chart</P></BODY></HTML> Wed, 17 May 2017 12:56:13 GMT vinieme12 2017-05-17T12:56:13Z set analysis expression https://community.qlik.com/t5/QlikView/set-analysis-expression/m-p/1360782#M417110 <HTML><HEAD></HEAD><BODY><P>need an expression as :</P><P></P><P><SPAN style="color: #000000; font-family: Segoe UI; font-size: 10pt;">Avg (field) used (percustomer) (value) based on one (field)</SPAN></P></BODY></HTML> Wed, 17 May 2017 11:41:28 GMT https://community.qlik.com/t5/QlikView/set-analysis-expression/m-p/1360782#M417110 Anonymous 2017-05-17T11:41:28Z Re: set analysis expression https://community.qlik.com/t5/QlikView/set-analysis-expression/m-p/1360783#M417111 <HTML><HEAD></HEAD><BODY><P>Not getting anything over here. IS this?</P><P><STRONG>Avg({&lt;percustomer = {'value'}&gt;}field)</STRONG></P></BODY></HTML> Wed, 17 May 2017 11:43:53 GMT https://community.qlik.com/t5/QlikView/set-analysis-expression/m-p/1360783#M417111 Anil_Babu_Samineni 2017-05-17T11:43:53Z Re: set analysis expression https://community.qlik.com/t5/QlikView/set-analysis-expression/m-p/1360784#M417112 <HTML><HEAD></HEAD><BODY><P>Hello, em... girl?</P><P></P><P>You can also try this avg(aggr(sum(value),field))</P></BODY></HTML> Wed, 17 May 2017 11:47:14 GMT https://community.qlik.com/t5/QlikView/set-analysis-expression/m-p/1360784#M417112 Sergey_Shuklin 2017-05-17T11:47:14Z Re: set analysis expression https://community.qlik.com/t5/QlikView/set-analysis-expression/m-p/1360785#M417113 <HTML><HEAD></HEAD><BODY><P>NOt sure what exactly? but think the TOTAL Keyword will work for you</P><P></P><P>AVG(&nbsp; TOTAL&nbsp; &lt;Country&gt;&nbsp;&nbsp;&nbsp;&nbsp; Sales)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;&lt;&nbsp; will give you total by each country ignoring other dimensions in chart</P></BODY></HTML> Wed, 17 May 2017 12:56:13 GMT https://community.qlik.com/t5/QlikView/set-analysis-expression/m-p/1360785#M417113 vinieme12 2017-05-17T12:56:13Z