topic Re: Expression help in QlikView

Expression help

apthansh — Wed, 25 Nov 2020 16:16:04 GMT

=If(GetSelectedCount(LuCurrencyType3) > 0,

num(sum(if([Expense Type]='Base Rent',

If([Year of Expense] = max([Year of Expense]),

[Expense Amount (USD)]/Factors))), '$(varCurrencySymbol) #,##0'),

num(sum(if([Expense Type]='Base Rent',

If([Year of Expense] = max([Year of Expense]),

[Expense Amount (USD)]))), '$(varCurrencySymbol) #,##0'))

Here I am getting an error saying Nested Aggregation not allowed and I guess it is because of

If([Year of Expense] = max([Year of Expense]),

How can I put this together.

Re: Expression help

swuehl — Mon, 09 Jan 2017 15:36:12 GMT

Maybe try

If([Year of Expense] = max(TOTAL [Year of Expense]),

or specify what exactely you want to achieve and how your model & data looks like.

Re: Expression help

sunny_talwar — Mon, 09 Jan 2017 15:37:29 GMT

You need to add an aggr() function after your sum because of what you are trying to do.... Alternatively, may be you just need to use set analysis if your comparison of Year of Expense to Max(Year of Expense) doesn't change based on your dimensions?

Re: Expression help

apthansh — Mon, 09 Jan 2017 15:48:02 GMT

Thnak you very much.That helped.