Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Partner - Champion
Partner - Champion

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

View solution in original post

2 Replies
OmarBenSalem

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

as dimension:

Name

as measure:

sum(Expense)

agigliotti
Partner - Champion
Partner - Champion

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