topic Re: AGGR average only on total line in QlikView https://community.qlik.com/t5/QlikView/AGGR-average-only-on-total-line/m-p/698597#M252246 <HTML><HEAD></HEAD><BODY><P>The only dimension is SubType a </P><P>Lower granularity grouping. </P></BODY></HTML> Wed, 02 Jul 2014 19:30:25 GMT 2014-07-02T19:30:25Z AGGR average only on total line https://community.qlik.com/t5/QlikView/AGGR-average-only-on-total-line/m-p/698595#M252244 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I have the following expression in a straight table with a single dimension.&nbsp; The problem I have is that the result only shows on the total line - i don't get averages per value in the dimension? Please can anyone advise?</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro _jivemacro_uid_14043120133381647 jive_macro_code" jivemacro_uid="_14043120133381647"> <P>Avg({$&lt;[Fiscal _DateSerial]={"&gt;=$(vL.12MthRolling)&lt;=$(vL.Period)"}, Type={'Non Pay'}&gt;} aggr(sum({$&lt;[Fiscal _DateSerial]={"&gt;=$(vL.12MthRolling)&lt;=$(vL.Period)"}, Type={'Non Pay'}&gt;} #Balances_In_Month_Actual),[Fiscal Year-Month]))</P> </PRE><P></P><P>Thanks</P><P></P><P>Dominic</P></BODY></HTML> Wed, 02 Jul 2014 14:39:40 GMT https://community.qlik.com/t5/QlikView/AGGR-average-only-on-total-line/m-p/698595#M252244 2014-07-02T14:39:40Z Re: AGGR average only on total line https://community.qlik.com/t5/QlikView/AGGR-average-only-on-total-line/m-p/698596#M252245 <HTML><HEAD></HEAD><BODY><P>Well, what are the chart dimensions (in order)?</P><P></P><P>Vlad</P></BODY></HTML> Wed, 02 Jul 2014 18:04:29 GMT https://community.qlik.com/t5/QlikView/AGGR-average-only-on-total-line/m-p/698596#M252245 vgutkovsky 2014-07-02T18:04:29Z Re: AGGR average only on total line https://community.qlik.com/t5/QlikView/AGGR-average-only-on-total-line/m-p/698597#M252246 <HTML><HEAD></HEAD><BODY><P>The only dimension is SubType a </P><P>Lower granularity grouping. </P></BODY></HTML> Wed, 02 Jul 2014 19:30:25 GMT https://community.qlik.com/t5/QlikView/AGGR-average-only-on-total-line/m-p/698597#M252246 2014-07-02T19:30:25Z Re: AGGR average only on total line https://community.qlik.com/t5/QlikView/AGGR-average-only-on-total-line/m-p/698598#M252247 <HTML><HEAD></HEAD><BODY><P>Add SubType to your aggr in that case, in addition to Fiscal Year-Month.</P><P></P><P>Vlad</P></BODY></HTML> Wed, 02 Jul 2014 22:07:47 GMT https://community.qlik.com/t5/QlikView/AGGR-average-only-on-total-line/m-p/698598#M252247 vgutkovsky 2014-07-02T22:07:47Z