Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
MVP
MVP

Re: SUM Column in text field

Hi,

Try like this

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

Hope this helps you.

Regards,

Jagan.

2 Replies
MVP
MVP

Re: SUM Column in text field

Hi,

Try like this

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

Hope this helps you.

Regards,

Jagan.

Not applicable

Re: SUM Column in text field

Thanks alot for your help!

Community Browser