topic Nested IF working for expression but not dimension in QlikView

Nested IF working for expression but not dimension

Tue, 26 May 2015 08:32:41 GMT

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

tresB — Tue, 26 May 2015 08:40:28 GMT

Try like:

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

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

Market))

Tue, 26 May 2015 08:41:09 GMT

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

hope that helps

Joe

Tue, 26 May 2015 08:46:45 GMT

that worked. Thanks!!!