Set Analysis and Aggr Rank

Wed, 30 Jan 2013 12:56:46 GMT

Hi All,

I have the following Calculated Dimension

if(aggr(Rank(ImpactRU),BUnitName,ReportingName,CoreBPName,SubBusinessProcessName,DeficiencyID,CalculationBasis) = 1, CalculationBasis,)

This returns me the row with the highest impactRU - I can then supress nulls on this column to get the top impactRU

However I also a set anaylis expression

count({$<DeficiencyCompliance = p([Control Compliance]),DeficiencyOpen={'Yes'} >} DeficiencyCount)

I want to find the impactRU using the AGGR function after the set analysis expression has been applied. however at the moment the AGGR function ignores my set anaylsis.

Can anyone help me conbine these two formulas?

Many thanks for you help

topic Set Analysis and Aggr Rank in QlikView

Set Analysis and Aggr Rank