# Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

## sum In chart

Hi,

My question is, how can I get a sum in the chart for Film, böcker and bio?

Now I only have a total sum for all the data in the chart.

Regards Karl

Tags (1)
1 Solution

Accepted Solutions
Employee

## Re: sum In chart

Hi Karl

Unfortunately Straight table does not support Partial Sums.

You need a Pivot table to do this and use the Show Partial Sum for the Sales Person column.

6 Replies
MVP

## Re: sum In chart

Trasform the table in a pivot table then in the tab presentation select  the field sales person and check show partial sum

let me know

Employee

## Re: sum In chart

Hi Karl

Unfortunately Straight table does not support Partial Sums.

You need a Pivot table to do this and use the Show Partial Sum for the Sales Person column.

Valued Contributor

## Re: sum In chart

Hi

You could actually achieve this by using Dimension Limits on the straight table and just selecting Show Total on the second dimension. However even if you can do this a Pivot Table might be the best solution. Below are screen shots of this being done with a straight table.

Not applicable

## Re: sum In chart

Have you tried using aggr function. You could then group by Salesperson. Like aggr(amount, Salesperson).

Hope this is clear.

Thanks,

Not applicable

## Re: sum In chart

Now I have a another question. I want to sum rows (ICA 2 Ica (böcker) 4% and (ICA Ica) and call the row lets say "Ica". How do I do that? Do I have to use an Expression? (what expression in that case)or is there a aggragate box to mark?

Regards

Karl

Valued Contributor

## Re: sum In chart

Hi, I would probably do this in the script with an if statement (if it is only this or a few other combinations).

You could do something like IF( [Chain No. & Name]= 'ICA 2 Ica (böcker) 4%')  or [Chain No. & Name] = 'ICA Ica', 'Ica', [Chain No. & Name])

Otherwise you could have an external or inline table with field translations.