Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
andy-w
Contributor II
Contributor II
‎2023-12-04 11:26 AM

Use a calculated field (master item) as a filter

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. 

 

Labels (2)
Labels
999 Views
0 Likes
1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP
‎2023-12-04 12:38 PM

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

971 Views