Use a calculated field (master item) as a filter

[andy-w]

I've made a new dimension, which is in the master items list. For some reason, I'm unable to use it as a filter in a chart. Any idea why?

The expression is similar to this:

=FIELDD='UnresolvedIntent' OR (FIELDA = 'Value' AND FIELDB = 'System' AND FIELDC='unresolved')

Note, I am able to use that field within a chart, but not as a filter. 

[rwunderlich]

In a chart, you likely have Dimension(s) that limit the FIELDD and FIELDA to one value so your test would work. To use this expression as a filter, you will need to add an Aggr that specifies what Dimension(s) you are "doing over" this expression. 

=Aggr(
FIELDD='UnresolvedIntent' OR (FIELDA = 'Value' AND FIELDB = 'System' AND FIELDC='unresolved')
, yourDImension)

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com