To show sum a group of values of same criteria as an expression in qlikview

[Anonymous]

Hi,

I have been try to achieve the summary of a particular selection as shown in the excel sheet on qlikview.

I have tried aggr, set analysis and have not reached anywhere.

Appreciate if someone could help on this.

Year	Portfolio	SumProduct	Value	Summary - Year - Portfolio	Ratio
2009	A	2009A	100	1500	6.67%
2009	A	2009A	200	1500	13.33%
2009	A	2009A	300	1500	20.00%
2009	A	2009A	400	1500	26.67%
2009	A	2009A	500	1500	33.33%
2009	B	2009B	600	4000	15.00%
2009	B	2009B	700	4000	17.50%
2009	B	2009B	800	4000	20.00%
2009	B	2009B	900	4000	22.50%
2009	B	2009B	1000	4000	25.00%
2010	C	2010C	1100	6500	16.92%
2010	C	2010C	1200	6500	18.46%
2010	C	2010C	1300	6500	20.00%
2010	C	2010C	1400	6500	21.54%
2010	C	2010C	1500	6500	23.08%
2010	D	2010D	1600	9000	17.78%
2010	D	2010D	1700	9000	18.89%
2010	D	2010D	1800	9000	20.00%
2010	D	2010D	1900	9000	21.11%
2010	D	2010D	2000	9000	22.22%

I have year and portfolio and the corresponding value as shown above.

In the column, Year-Portfolio summary, I need to show the total sum for the respective year and portfolio so that I can check the percentage of this value for the whole of the portfolio for that year.

Eg. for 2009 and product A, the sum of values = 100+200+300+400+500 = 1500 - which is shown in Summary - Portfolio - Year

This has to happen for all respective year and portfolio.

I know it should be something achievable but somehow I am not able to figure out how to do it.

I could do it on excel -- see attachment, but not on qlikview.

Please help.

Thanks,

Bino.

[learnerqlik53]

Hi All,

I have similar request like above. @Anonymous @Miguel_Angel_Baeyens @IAMDV @Anonymous @saranshbh 

For Total Meeting i gave formula: =sum(Total <Month, Name> Meeting1 ) But in Total Meeting all columns I am not getting summation of this grouping. Could you please check what is the issue.

Year	Month	Name	Meeting1	Total Meeting
				10
2020	Jan	Amita	3	3
2020	Feb	Amita	0	0
2020	Mar	Amita	0	0
2020	Apr	Amita	0	0
2020	May	Amita	0	0
2020	Jun	Amita	0	0
2020	Jul	Amita	0	0
2020	Jan	Heena	1	1
2020	Feb	Heena	0	0
2020	Mar	Heena	0	0
2020	Apr	Heena	0	0
2020	May	Heena	0	0
2020	Jun	Heena	0	0
2020	Jul	Heena	0	0

Thanks in advance!

[learnerqlik53]

Hi All,

I tried =sum(Total <Name> Meeting1 ) and it worked.  To summarize this i think we need to put columns on which we want to do grouping inside closed "<>" Thanks!

Year	Month	Name	Meeting1	Total Meeting
				10
2020	Jan	Amita	3	3
2020	Feb	Amita	0	3
2020	Mar	Amita	0	3
2020	Apr	Amita	0	3
2020	May	Amita	0	3
2020	Jun	Amita	0	3
2020	Jul	Amita	0	3
2020	Jan	Heena	1	1
2020	Feb	Heena	0	1
2020	Mar	Heena	0	1
2020	Apr	Heena	0	1
2020	May	Heena	0	1
2020	Jun	Heena	0	1
2020	Jul	Heena	0	1