Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

SUM Column in text field

Hi all,

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

NameProjectnumberUnitUnitvalue
AmountTotal in hours
David126456345612Hour11212
Mark312413534634Day8432

How can i Sum the Total in hours column?

Kind regards,

Marco

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Hi,

Try like this

=Sum(Aggr(sum(Amount)*[UnitValue], Name, ProjectNumber, Unit))

Hope this helps you.

Regards,

Jagan.

View solution in original post

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Hi,

Try like this

=Sum(Aggr(sum(Amount)*[UnitValue], Name, ProjectNumber, Unit))

Hope this helps you.

Regards,

Jagan.

View solution in original post

Highlighted
Not applicable

Thanks alot for your help!