Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

joshuagoh
New Contributor

Sum rows with the same name

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!

1 Solution

Accepted Solutions
agigliotti
Honored Contributor II

Re: Sum rows with the same name

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

2 Replies
OmarBenSalem
Esteemed Contributor

Re: Sum rows with the same name

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

as dimension:

Name

as measure:

sum(Expense)

agigliotti
Honored Contributor II

Re: Sum rows with the same name

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

Community Browser