topic Aggr over caluculated dimension in QlikView https://community.qlik.com/t5/QlikView/Aggr-over-caluculated-dimension/m-p/392289#M146338 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a Pivot Table with 3 dimensions. 1 dimension is a consists of an if-statement. Since QV once again gives me wrong sum in my expression, I want to do an SUM(AGGR( over all dimensions to influence the total sum. Is it possible to make an aggr over a calculated dimension? my dimension is </P><P>=if (A='Bis',vLastDayPreviousMonth,date(Date))</P><P></P><P>Thank you.</P><P></P><P>Br, Michael</P></BODY></HTML> Tue, 26 Mar 2013 09:13:09 GMT michael_maeuser 2013-03-26T09:13:09Z Aggr over caluculated dimension https://community.qlik.com/t5/QlikView/Aggr-over-caluculated-dimension/m-p/392289#M146338 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a Pivot Table with 3 dimensions. 1 dimension is a consists of an if-statement. Since QV once again gives me wrong sum in my expression, I want to do an SUM(AGGR( over all dimensions to influence the total sum. Is it possible to make an aggr over a calculated dimension? my dimension is </P><P>=if (A='Bis',vLastDayPreviousMonth,date(Date))</P><P></P><P>Thank you.</P><P></P><P>Br, Michael</P></BODY></HTML> Tue, 26 Mar 2013 09:13:09 GMT https://community.qlik.com/t5/QlikView/Aggr-over-caluculated-dimension/m-p/392289#M146338 michael_maeuser 2013-03-26T09:13:09Z