topic Re: Before function in QlikView https://community.qlik.com/t5/QlikView/Before-function/m-p/284359#M105699 <HTML><HEAD></HEAD><BODY><P>Hi Kamielrajaram,</P><P></P><P>I am not sure if I got your request properly, but I think you could get what you want if you combine dimnesionality() to check if your on total line, bottom() to get the last line and advanced aggregation to rebuild the table on total line virtually, maby like</P><P></P><P>=if(secondarydimensionality()=0,sum(aggr(aggr( bottom(sum(Value),2),Group,Article),Group)),before(sum(Value)))</P><P></P><P>The exact expression will depend on the orientation of your pivot dimensions, so I added two examples with dimensions in horizontal or vertical orientation.</P><P></P><P>Hope this helps,</P><P>Stefan</P></BODY></HTML> Fri, 23 Sep 2011 09:38:09 GMT swuehl 2011-09-23T09:38:09Z Before function https://community.qlik.com/t5/QlikView/Before-function/m-p/284358#M105698 <HTML><HEAD></HEAD><BODY><P><BR />Good day all,</P><P></P><P>I am using the before function and it works fine, the problem is that I need a value in the total column. I have 2 dimensions, groups and weeks. the final value for each group needs to be added to give me a total value. Any help would be appreciated.</P><P></P><P>Regards</P><P></P><P>Kamiel</P></BODY></HTML> Fri, 23 Sep 2011 07:39:22 GMT https://community.qlik.com/t5/QlikView/Before-function/m-p/284358#M105698 kamielrajaram 2011-09-23T07:39:22Z Re: Before function https://community.qlik.com/t5/QlikView/Before-function/m-p/284359#M105699 <HTML><HEAD></HEAD><BODY><P>Hi Kamielrajaram,</P><P></P><P>I am not sure if I got your request properly, but I think you could get what you want if you combine dimnesionality() to check if your on total line, bottom() to get the last line and advanced aggregation to rebuild the table on total line virtually, maby like</P><P></P><P>=if(secondarydimensionality()=0,sum(aggr(aggr( bottom(sum(Value),2),Group,Article),Group)),before(sum(Value)))</P><P></P><P>The exact expression will depend on the orientation of your pivot dimensions, so I added two examples with dimensions in horizontal or vertical orientation.</P><P></P><P>Hope this helps,</P><P>Stefan</P></BODY></HTML> Fri, 23 Sep 2011 09:38:09 GMT https://community.qlik.com/t5/QlikView/Before-function/m-p/284359#M105699 swuehl 2011-09-23T09:38:09Z