Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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].
try this dimension
=aggr(only({<dim=P({$}dim)>}dim),dim)
or
=aggr(count({<dim=P({$}dim)>}dim),dim)
Use Count({< [Category]=>}[Employees])
Its enough to say
Count({<Category>} Employees)
The Category Dimension exists as a Master Item so I am not sure how to reference this in the expression?
try to edit the master item and include the expression and save.