Solved: SUM(value) for record / SUM(value) for all records... - Qlik Community

Report Inappropriate Content · ‎2014-01-21

I have the following dataset

I have ListView with Year and this control allows me to filter dataset by year

I have a Chart (table) with cyclic group by Product. Then I SUM(Value) for those groups

I have something like this when I filter Year = 2012:

Product	SUM(Value)
MAC	3
PC	4

Now I'd like to add the following column :

Product	SUM(Value)	SUM(Value) / TOTALSUM(Value)
MAC	3	3 / 7
PC	4	4 / 7

Note: record for year 2011 is not included in calculation.

How to get this 7?

alexandros17 · ‎2014-01-21

simply sum(Total value)

hope it helps

alexandros17 · ‎2014-01-21

simply sum(Total value)

hope it helps

Report Inappropriate Content · ‎2014-01-21

WOW! Thanks!

SUM(value) for record / SUM(value) for all records in chart