Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Dayna
Creator II
Creator II

Aggr Help!

Hello All,

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.

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.

So I was thinking an aggr expression, i.e. aggr(Cost * LabourRate, AddedBy) but I can't get it to work!

I've attached my application, if someone could provide some help it would be most appreciated.

Kind Regards,

Dayna

0 Replies