Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try like:
=IF([launched in last 6 months]='Yes',0,
IF(Aggr(SUM({1<WeeksAgo={'<=12'}>}Revenue),Market)=0,0,
Market))
Try like:
=IF([launched in last 6 months]='Yes',0,
IF(Aggr(SUM({1<WeeksAgo={'<=12'}>}Revenue),Market)=0,0,
Market))
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
QlikView Technical Brief - AGGR
hope that helps
Joe
that worked. Thanks!!!