topic Re: Partial Average in QlikView https://community.qlik.com/t5/QlikView/Removed/m-p/1307604#M406820 <HTML><HEAD></HEAD><BODY><P>Okay, Then please provide sample data</P></BODY></HTML> Tue, 09 May 2017 10:44:16 GMT Anil_Babu_Samineni 2017-05-09T10:44:16Z Removed https://community.qlik.com/t5/QlikView/Removed/m-p/1307599#M406815 Wed, 14 Aug 2019 07:09:41 GMT https://community.qlik.com/t5/QlikView/Removed/m-p/1307599#M406815 heena_shaikh 2019-08-14T07:09:41Z Re: Partial Average https://community.qlik.com/t5/QlikView/Removed/m-p/1307600#M406816 <HTML><HEAD></HEAD><BODY><P>Try to do it Expression for RangeAvg like</P><P><STRONG>RangeAvg(Field1, Field2 ...Fieldn)</STRONG></P></BODY></HTML> Tue, 09 May 2017 09:14:15 GMT https://community.qlik.com/t5/QlikView/Removed/m-p/1307600#M406816 Anil_Babu_Samineni 2017-05-09T09:14:15Z Removed https://community.qlik.com/t5/QlikView/Removed/m-p/1307601#M406817 Wed, 14 Aug 2019 07:08:35 GMT https://community.qlik.com/t5/QlikView/Removed/m-p/1307601#M406817 heena_shaikh 2019-08-14T07:08:35Z Re: Partial Average https://community.qlik.com/t5/QlikView/Removed/m-p/1307602#M406818 <HTML><HEAD></HEAD><BODY><P>You can use the function Dimensionality() to have the expression dependant on the dimension<SPAN style="font-size: 10pt; line-height: 1.5em;"> level.</SPAN></P><P></P><P><EM>=If(</EM><SPAN style="font-size: 13.3333px;"><EM>Dimensionality() = 1, &lt;expression for dimension level 1&gt;, ....)</EM></SPAN></P><P></P><P>If the dimensions are across the top, then you should use SecondaryDimensionality() instead.</P></BODY></HTML> Tue, 09 May 2017 09:58:11 GMT https://community.qlik.com/t5/QlikView/Removed/m-p/1307602#M406818 jonathandienst 2017-05-09T09:58:11Z Re: Partial Average https://community.qlik.com/t5/QlikView/Removed/m-p/1307604#M406820 <HTML><HEAD></HEAD><BODY><P>Okay, Then please provide sample data</P></BODY></HTML> Tue, 09 May 2017 10:44:16 GMT https://community.qlik.com/t5/QlikView/Removed/m-p/1307604#M406820 Anil_Babu_Samineni 2017-05-09T10:44:16Z