Aggregated expression

jessica_webb — Wed, 25 Nov 2020 16:16:04 GMT

I have a very large table with the following 3 dimensions

and 6 expressions:

ID	Type	Set	SUM({<GEN={'ALL'}>}NUM)	AGGR(NODISTINCT SUM({<GEN={'ALL'}>} ID	AGGR(NODISTINCT SUM({<GEN={'ALL'}>} NUM),Type_Set)	SUM(TOTAL {<GEN={'ALL'}>} NUM)	SUM({<GEN={'ALL'}>}NUM)/AGGR(NODISTINCT SUM({<GEN={'ALL'}>} NUM),ID)	AVG(SUM({<GEN={'ALL'}>}NUM)/AGGR(NODISTINCT SUM({<GEN={'ALL'}>} NUM),ID))
123	A	NAERG	33	1794	41073	5544553	0.0184	0.019246154
123	A	BZFAW	57	1794	180841	5544553	0.0318	0.019246154
123	A	AQEGA	64	1794	152782	5544553	0.0357	0.019246154
123	A	HSSMFM	15	1794	27766	5544553	0.0084	0.019246154
387	A	AEGGV	10	1729	707	5544553	0.0058	0.019246154
387	A	ASDFBT	12	1729	36537	5544553	0.0069	0.019246154
387	A	MGFMNS	101	1729	82458	5544553	0.0584	0.019246154
387	A	NEATN	33	1729	69241	5544553	0.0191	0.019246154
914	A	MGFMNS	30	1751	82458	5544553	0.0171	0.019246154
914	A	AETWAQ	35	1751	139096	5544553	0.02	0.019246154
914	A	DTUKDTUJ	20	1751	99431	5544553	0.0114	0.019246154
914	A	STJN	15	1751	151647	5544553	0.0086	0.019246154
914	A	AWEGG	15	1751	7527	5544553	0.0086	0.019246154

My problem is with the final expression. I have displayed in the table the value I would like to see (which is an average of all the values in the 5th column), but the expression doesn't work as it currently is.

Hope this is explained clearly - help would be much appreciated!

Re: Aggregated expression

kaushiknsolanki — Wed, 28 Jun 2017 10:56:57 GMT

Kindly Share your application.

Regards,

Kaushik Solanki

Re: Aggregated expression

sunny_talwar — Wed, 28 Jun 2017 11:05:35 GMT

May be try this

Avg(TOTAL Aggr(Sum({<GEN={'ALL'}>}NUM)/Sum(TOTAL <ID> {<GEN={'ALL'}>} NUM), ID, Type, Set))

Re: Aggregated expression

jessica_webb — Wed, 28 Jun 2017 12:09:23 GMT

Thank you Sunny!

Another quick,simple solution

Much appreciated,

Jess

topic Re: Aggregated expression in QlikView

Aggregated expression

Re: Aggregated expression

Re: Aggregated expression

Re: Aggregated expression