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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Chart that ignores certain filters

I have a chart in Qlik that I would like to ignore certain filters but still be able to filter with other filters. How do I do this?

I want to count [Employees], be able to filter by [Week] but not by [Category].

5 Replies
Chanty4u
MVP
MVP

try this dimension

=aggr(only({<dim=P({$}dim)>}dim),dim)


or


=aggr(count({<dim=P({$}dim)>}dim),dim)

prat1507
Specialist
Specialist

Use Count({< [Category]=>}[Employees])

jonathandienst
Partner - Champion III
Partner - Champion III

Its enough to say

     Count({<Category>} Employees)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable
Author

The Category Dimension exists as a Master Item so I am not sure how to reference this in the expression?

Chanty4u
MVP
MVP

try to edit the master item and include the expression and save.