Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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.