topic How to sum distinct dimensions in QlikView

How to sum distinct dimensions

Mon, 26 Jan 2026 18:19:17 GMT

Hi there,

I have a table like this:

Year	Month	Field 1	Field 2	Field 3	Vol
2012	11	S	G	L	100
2012	11	S	O	L	150
2012	11	S	G	C	100
2012	11	S	O	C	150
2012	11	S	P	C	200
2013	1	S	G	L	100
2013	1	S	O	L	75
2013	1	S	G	C	100
2013	1	S	O	C	75
2013	1	S	P	C	200
2013	1	S	S	C	75

And I want to get the sum of all the distincts Field 2, like this

to create a table which displays the sum (vol) by Field 3 and the Total Vol (sum all distincts Field 2) by year, exactly like this:

I've tried

Total vol = sum(TOTAL aggr(sum(distinct Vol),Field 1,Field 2) )

but only works when I select a year and a month

Thanks,

Bere

Tue, 16 Jul 2013 06:00:28 GMT

try this code

take a pivot table--

Dimension is Year, Field1, Field2, Field3, Month

in expression

sum(Aggr(sum(DISTINCT Vol),[Field 2],Year))

then in presentation tab select Field2 and then check on Partial sum

then output like this

see ttachement

kaushiknsolanki — Tue, 16 Jul 2013 06:38:50 GMT

Hi,

Try this.

Create a chart with dimensions as Field1,Field2,Year,Month

And expression as

Vol : - Sum(Vol)

Total Vol : - Sum(Total <Year> Vol)

Regards,

Kaushik Solanki