topic Max Aggr value regardless of selection in field! Please Help! in QlikView

Max Aggr value regardless of selection in field! Please Help!

Mon, 13 Dec 2010 16:41:21 GMT

Hi All

I have the following formula that gives me the period with the maximum value:

[CODE]=max(aggr(Sum({$<[4AN - Level 4 Account Name] = {'Non Pay Costs'},Period={'*'}>} Actuals*LY1_Flag),Period))

Problem is I want this to stay the same regardless of any selection in the Period field, I added the Period={'*'} to the set analysis in the hope that this would work but something with the aggr means it still only gives me the max of the current;y selected periods.

Please can anyone advise a way to fix this or do it in another way?

Thanks

Dominic

Max Aggr value regardless of selection in field! Please Help!

Mon, 13 Dec 2010 16:51:36 GMT

To ignore the selection on Period, add Period= with no Set Modifier to your Set Analysis.

=max(aggr(Sum({$<[4AN - Level 4 Account Name] = {'Non Pay Costs'},
 Period=>} Actuals*LY1_Flag),Period))

EDIT: Since you have two aggregate functions, you may need to add Period= to your Max as well. I'm not sure, but if that one doesn't work, you may want to put your Set Analysis in the Max too.

=max({<Period=>}aggr(Sum({$<[4AN - Level 4 Account Name] = {'Non Pay Costs'},
 Period=>} Actuals*LY1_Flag),Period))

Max Aggr value regardless of selection in field! Please Help!

Mon, 13 Dec 2010 16:59:54 GMT

Sweet thanks! I did have to add the set analysis to the Max bu that worked really well.