Sum rows with the same name

[Anonymous]

Hi all,

I need some help with the following problem in Qliksense.

I'm loading an excel with the following data:

Name | Expense

A        | $35

B        | $10

A        | $20

B        | $25

C        | $15

And I would like to put it into a table that consolidates all the unique Names:

ie.

Name | Expense

A        | $55

B        | $35

C        | $15

How do I perform this in Qliksense?

Thanks!

[OmarBenSalem]

create a simple table in qlik sense (in the sheet not the script)

as dimension:

Name

as measure:

sum(Expense)

[agigliotti · Accepted solution]

you can do also in script as below:

LOAD

     Name,

     Sum(Expense) as Expense

FROM yourTable Group By Name;

in your chart object you can use:

Name as dimension

Expense as Measure