Nested IF working for expression but not dimension

[#1]

Oddly the below expression works fine as my dimension in a straight table

=IF([launched in last 6 months]='Yes',0,Market)

But when I add a 2nd IF statement to it, i get 'Error in Calculated dimension'

=IF([launched in last 6 months]='Yes',0,

       IF(SUM({1<WeeksAgo={'<=12'}>}Revenue)=0,0,

            Market))

What's even weirder is that this works fine when used as an expression, rather than a dimension

[tresesco · Accepted solution]

Try like:

=IF([launched in last 6 months]='Yes',0,

       IF(Aggr(SUM({1<WeeksAgo={'<=12'}>}Revenue),Market)=0,0,

            Market))

[#3]

Hi Alex,

you can't use an aggregation function in a calculated dimension, without wrapping it in aggr. Have a look at the below for help

AGGR...

QlikView Technical Brief - AGGR

hope that helps

Joe

[#4]

that worked. Thanks!!!