Discussion Board for collaboration on QlikView Layout & Visualizations.
Short question, I'm trying to calculate the total of an expression. The expression is positioned in an pivot table. How can i create a SUM of the expession in a textfield outside the pivottable?
Inside the table i use the following: =sum(Amount)*[UnitValue]
The goal is to sum the total hours in the data show in the table in a text field next to the table. look at the example below
How can i Sum the Total in hours column?
Try like this
=Sum(Aggr(sum(Amount)*[UnitValue], Name, ProjectNumber, Unit))
Hope this helps you.
View solution in original post
Thanks alot for your help!