Aggregation issue

renjithpl — Fri, 06 Jun 2014 07:55:26 GMT

Hi All,

I have table like below

Name on Top 20	Existing Managed SPVs	Exposure (AUD)	Risk Weight	Risk Weighted Assets
FP Turbo Trust AUD	FP Turbo Trust AUD (Senior)	$202,648,646.66	0.07	$14,185,405.27
FP Turbo Trust AUD	FP Turbo Trust AUD (Mezz)	$9,737,662.24	0.15	$1,460,649.34
FP Turbo Trust AUD	FP Turbo Trust AUD (Junior)	$7,105,861.64	0.2	$1,421,172.33
Total	Total	$219,492,170.54		$17,067,226.93

I want to calculate the Risk Weighted Assets, the formula = Sum([Exposure (AUD)]) * Risk Weight

Now, I will remove "Exixting Managed SPVs" in my orginal Chart, I get Risk Weighted Assets null, like in below chart, which is obvious that we have different risk weights. (0.07, 0.15, 0.2)

Name on Top 20	Exposure (AUD)	Risk Weight	Risk Weighted Assets
FP Turbo Trust AUD	$219,492,170.54	-	-
Total	$219,492,170.54		$0.00

I want the table like below:

Name on Top 20	Exposure (AUD)	Risk Weight	Risk Weighted Assets
FP Turbo Trust AUD	$219,492,170.54	-	$17,067,226.93

Any idea ?

Ren

Re: Aggregation issue

tresB — Fri, 06 Jun 2014 08:04:54 GMT

Try:

=Sum( [Exposure (AUD)] * Risk Weight )

topic Re: Aggregation issue in QlikView

Aggregation issue

Re: Aggregation issue