topic Expression doesn't work as dimension in QlikView

Expression doesn't work as dimension

Mon, 14 Apr 2014 16:45:20 GMT

Any idea why the below expression is returning //Error in calc... when I put it in the dimension?

Alt(only({<[Classification Source]={'$(=[Classification Source1])'}>}[Asset Classification (1)]),

only({<[Classification Source]={'$(=[Classification Source2])'}>}[Asset Classification (1)]),

only({<[Classification Source]={'$(=[Classification Source3])'}>}[Asset Classification (1)]),

only({<[Classification Source]={'$(=[Classification Source4])'}>}[Asset Classification (1)]),

only({<[Classification Source]={'$(=[Classification Source5])'}>}[Asset Classification (1)]),

'NULL_CLASS')

Class Source1-n above are islands which are user selections.

Re: Expression doesn't work as dimension

whiteline — Mon, 14 Apr 2014 17:03:37 GMT

Hi.

Because you have to use aggr() function for calculated dimension.

Re: Expression doesn't work as dimension

Anonymous — Mon, 14 Apr 2014 17:04:09 GMT

I suspect there is a better way to handle your situation, but if you prefer this way, try to use aggr() around this expression:

aggr(

, [Asset Classification (1)]))

Re: Expression doesn't work as dimension

Mon, 14 Apr 2014 17:12:46 GMT

the aggr() works except it doesn't populate 'NULL_CLASS' for nulls. Would definitely be interested in a better way to handle this if you have any ideas.

EDIT: This actually doesn't resolve the issue. It generates values for the dimension, but when I switch to a pivot, it does not group the like values together.

Re: Expression doesn't work as dimension

Anonymous — Mon, 14 Apr 2014 17:23:03 GMT

A better way is to create an actual dimension in the data model, if possible of course.