aggr - aggregated minimum/Maximum calculation regardless of selection in field

Wed, 15 Sep 2010 08:49:08 GMT

Hi All

I'm calculating a rank for a minichart in a straight table and have dynamic min and max. For the min and max functions I'm using the aggr function with a min. Here's the function:

[CODE] =min(total aggr(Sum ({$<[4AC - Level 4 Account Code] = {'PAY','NONPAY','INCOME'},[4AN - Level 4 Account Name] = {'Pay Costs','Non Pay Costs','Income'}>} Actuals*CalCurYTDFlag)-sum({$<[4AC - Level 4 Account Code] = {'PAY','NONPAY','INCOME'},[4AN - Level 4 Account Name] = {'Pay Costs','Non Pay Costs','Income'}>} [Budget 1]*CalCurYTDFlag),ExpenseGrp))[/CODE]

The problem I'm having is that when a selection is made in the field [4AC - Level 4 Account Code] this reduces the available values in ExpenseGrp and the aggregation only then aggregates on the remaining available values - I want it to aggregate by all values available in ExpenseGrp with the selection as per the set analysis, i.e. [4AC - Level 4 Account Code] = {'PAY','NONPAY','INCOME'}. Like set analysis for the aggr section (but that doesn't work).

Many thanks

Dominic

topic aggr - aggregated minimum/Maximum calculation regardless of selection in field in QlikView

aggr - aggregated minimum/Maximum calculation regardless of selection in field