Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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