topic Re: sum In chart in Qlik Learning Discussions

sum In chart

Tue, 21 Oct 2014 14:17:13 GMT

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

Re: sum In chart

alexandros17 — Tue, 21 Oct 2014 14:22:33 GMT

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

Re: sum In chart

Agis-Kalogiannis — Tue, 21 Oct 2014 14:27:55 GMT

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.

Re: sum In chart

Anonymous — Tue, 21 Oct 2014 15:01:37 GMT

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.

Re: sum In chart

Tue, 21 Oct 2014 17:51:54 GMT

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

Hope this is clear.

Thanks,

Madhu

Re: sum In chart

Wed, 22 Oct 2014 14:17:51 GMT

Thank you for all your answers. They have been very helpful.

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

Re: sum In chart

Anonymous — Wed, 22 Oct 2014 14:53:22 GMT

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.