Help with aggr Function

Thu, 16 Oct 2014 17:31:02 GMT

I was trying to use aggr function to show the totals on a straight table but having issues with it and unable to understand what is missing. Hope someone could help on this please. You can find the below table to show what is done exactly

Dim	Expression(1)=Sum({<Set analysis criteria>}field ABC)	Experssion(2)=Sum({<Set analysis criteria>}Field xyz)	Expression(2)/expression(1)
	256	$448	-
STO	7	$255	$36
Kid	10	$0	$0
RAP	10	$0	$0
Res	10	$25	$3
Exi	15	$0	$0
Pan	15	$35	$2
06-	16	$0	$0
Doc	17	$0	$0
Eva	18	$0	$0
Hon	18	$0	$0
DET	20	$0	$0
Hi	20	$34	$2
Pul	20	$0	$0
Rav	20	$99	$5
Rev	20	$0	$0
SAI	20	$0	$0

the expression i am tryin to use for the right most column is

=Sum(aggr(Sum({<Set analysis criteria>}field ABC)/Sum({<Set analysis criteria>}Field xyz),dim))

not only this i have tried to use the total in the expression and even removing the aggr and just use total is not working.

The problem is that i need values to show expression up by each dimensional value and the total on the top and the in the properties-->expression--> when i check the option expression total its not showing up.

Thanks in advance.

Re: Help with aggr Function

wms_manis — Thu, 16 Oct 2014 19:35:18 GMT

Not real sure what you are trying to do, but if you want a total based on a set expression you can use the total qualifier.

sum({$<p1={'R*'}>}total value) //sum up all the p1 values that start with R. This returns 60.

you can do the division but basically you can calculate a total value for a set condition and divide it by another value.

See attachment.

p1	sum(value)	*sum({$<p1={'R'}>}total value)**	*aggr(sum({1<p1={'R'}>}value),p1)**	*sum({$<p1={'D'}>}Total value)**
	256	60		37
06-	16	60		37
DET	20	60		37
Doc	17	60		37
Eva	18	60		37
Exi	15	60		37
Hi	20	60		37
Hon	18	60		37
Kid	10	60		37
Pan	15	60		37
Pul	20	60		37
RAP	10	60	10	37
Rav	20	60	20	37
Res	10	60	10	37
Rev	20	60	20	37
SAI	20	60		37
STO	7	60		37

topic Help with aggr Function in QlikView

Help with aggr Function

Re: Help with aggr Function