topic Help with Aggr function with Class and Alternate States in QlikView https://community.qlik.com/t5/QlikView/Help-with-Aggr-function-with-Class-and-Alternate-States/m-p/853752#M299305 <HTML><HEAD></HEAD><BODY><P>I am trying to show movements of subs between bands over a period. Thanks to <A href="https://community.qlik.com/qlik-users/171708">sunindia</A>‌ I have managed to reach so far and now am&nbsp; trying to use the expression below</P><P></P><P><SPAN style="color: #0000ff; font-size: 12pt;">Aggr</SPAN><SPAN style="font-size: 12pt;">(<SPAN style="color: #0000ff;">Class</SPAN>(<SPAN style="color: #0000ff;">sum</SPAN>({<SPAN style="color: #0000ff;">State1</SPAN>}<SPAN style="color: #800000;">MoU</SPAN>),<STRONG><EM style="color: #808080; font-size: 8pt;">v_mou_int</EM></STRONG>,'MoU'),<SPAN style="color: #800000;">BC_MONTH</SPAN>,<SPAN style="color: #800000;">SUB_ID</SPAN>,<SPAN style="color: #800000;">SERVICE</SPAN></SPAN><SPAN style="font-size: 12pt;">) </SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">This is in MoU bands and this returns //Error in calculation.</SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">But this expression seems to work in the list box but not in my Pivot where am trying to use this as a dimension.</SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">Can anyone help ?</SPAN></P><P><SPAN><SPAN></SPAN></SPAN> </P><P><SPAN><SPAN></SPAN></SPAN></P><P> </P><P></P></BODY></HTML> Sat, 04 Apr 2015 12:49:49 GMT 2015-04-04T12:49:49Z Help with Aggr function with Class and Alternate States https://community.qlik.com/t5/QlikView/Help-with-Aggr-function-with-Class-and-Alternate-States/m-p/853752#M299305 <HTML><HEAD></HEAD><BODY><P>I am trying to show movements of subs between bands over a period. Thanks to <A href="https://community.qlik.com/qlik-users/171708">sunindia</A>‌ I have managed to reach so far and now am&nbsp; trying to use the expression below</P><P></P><P><SPAN style="color: #0000ff; font-size: 12pt;">Aggr</SPAN><SPAN style="font-size: 12pt;">(<SPAN style="color: #0000ff;">Class</SPAN>(<SPAN style="color: #0000ff;">sum</SPAN>({<SPAN style="color: #0000ff;">State1</SPAN>}<SPAN style="color: #800000;">MoU</SPAN>),<STRONG><EM style="color: #808080; font-size: 8pt;">v_mou_int</EM></STRONG>,'MoU'),<SPAN style="color: #800000;">BC_MONTH</SPAN>,<SPAN style="color: #800000;">SUB_ID</SPAN>,<SPAN style="color: #800000;">SERVICE</SPAN></SPAN><SPAN style="font-size: 12pt;">) </SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">This is in MoU bands and this returns //Error in calculation.</SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">But this expression seems to work in the list box but not in my Pivot where am trying to use this as a dimension.</SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">Can anyone help ?</SPAN></P><P><SPAN><SPAN></SPAN></SPAN> </P><P><SPAN><SPAN></SPAN></SPAN></P><P> </P><P></P></BODY></HTML> Sat, 04 Apr 2015 12:49:49 GMT https://community.qlik.com/t5/QlikView/Help-with-Aggr-function-with-Class-and-Alternate-States/m-p/853752#M299305 2015-04-04T12:49:49Z Re: Help with Aggr function with Class and Alternate States https://community.qlik.com/t5/QlikView/Help-with-Aggr-function-with-Class-and-Alternate-States/m-p/853753#M299306 <HTML><HEAD></HEAD><BODY><P>Answered <A _jive_internal="true" href="https://community.qlik.com/message/746705#746705">https://community.qlik.com/message/746705#746705</A></P></BODY></HTML> Tue, 07 Apr 2015 08:25:36 GMT https://community.qlik.com/t5/QlikView/Help-with-Aggr-function-with-Class-and-Alternate-States/m-p/853753#M299306 2015-04-07T08:25:36Z