topic Aggr Help! in QlikView https://community.qlik.com/t5/QlikView/Aggr-Help/m-p/296700#M499328 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I have a slightly complex expression that is used to calculate how much time has been added, what I need to do is multiple this by the LabourRate. </P><P></P><P>I originally had an InputSum() field, but what I can't have is the labour rate summed then multiplied by the amount of time as the figures are completely skewed! The labour rate is unique to the user.</P><P></P><P>So I was thinking an aggr expression, i.e. aggr(Cost * LabourRate, AddedBy) but I can't get it to work!</P><P></P><P>I've attached my application, if someone could provide some help it would be most appreciated.</P><P></P><P>Kind Regards,</P><P>Dayna</P></BODY></HTML> Fri, 13 May 2011 08:48:45 GMT Dayna 2011-05-13T08:48:45Z Aggr Help! https://community.qlik.com/t5/QlikView/Aggr-Help/m-p/296700#M499328 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I have a slightly complex expression that is used to calculate how much time has been added, what I need to do is multiple this by the LabourRate. </P><P></P><P>I originally had an InputSum() field, but what I can't have is the labour rate summed then multiplied by the amount of time as the figures are completely skewed! The labour rate is unique to the user.</P><P></P><P>So I was thinking an aggr expression, i.e. aggr(Cost * LabourRate, AddedBy) but I can't get it to work!</P><P></P><P>I've attached my application, if someone could provide some help it would be most appreciated.</P><P></P><P>Kind Regards,</P><P>Dayna</P></BODY></HTML> Fri, 13 May 2011 08:48:45 GMT https://community.qlik.com/t5/QlikView/Aggr-Help/m-p/296700#M499328 Dayna 2011-05-13T08:48:45Z