Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Trich
Contributor
Contributor

Dimensions not matching Totals with Set Analysis

Hi,

I am have problems with my row amounts  when using set analysis and dimensions.

Trich_0-1677171177473.png

So the formula for % Total AV Test 2 .  It has percent in the name since working toward dividing. This is the correct total

if(vMeasureTimeframe='Last 12 Months'
,sum({<[Cycle Date]={"$(=Max([Cycle Date]))"},IssueDate={">=$(=vMinIssueDate)"}>} Total Contract_FundValue)
,sum({<[Cycle Date]={"$(=Max([Cycle Date]))"}>} Total Contract_FundValue)
)

Now when I try to break out this total across the dimension Rider_Type_BuyUp  it not getting amounts that add up to total.

My formula for %Total AV Test 1 is as follows

sum(aggr(if(vMeasureTimeframe='Last 12 Months'
,sum( {<ProductType={'FIA'},[Cycle Date]={"$(=Max([Cycle Date]))"},IssueDate={">=$(=vMinIssueDate)"}>} Contract_FundValue)
,sum({<ProductType={'FIA'},[Cycle Date]={"$(=Max([Cycle Date]))"}>} Contract_FundValue)
),Rider_Type_BuyUp))

I also tried to wrap the sum aggr around each if condition and got the same result. So, I want the column % Total AV Test 1 to equal the % Total AV Test 2.

Here how the formula for % Total AV Test 2 reconciles

Trich_1-1677172149283.png

Any help would be appreciated!

Labels (1)
0 Replies