Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mpalha
Contributor III
Contributor III

Ignoring a Filter/Master Dimsension

Hello,

I have a master dimension for Type with the formula below. It is being used as a filter in my report.

=If(Not Match(type, 'Control'), channel)

I'd like my master measure for Base Sales below to ignore this filter when a value(s) is selected. 

Sum({<type={'Control'}>}sales)

The filter ignores the values where type=Control, whereas the Base Sales only looks at values with type=Control. I'd like Base Sales to stay static when the Type filter is selected. How do I write my formula for Base Sales so that it still sums where type=Control, yet ignores the filter which removes type=Control?

1 Reply
micheledenardi
Specialist II
Specialist II

Your question is not so clear... the expression you wrote "sum({<type={'Control'}>}sales)"  sum all  sales where type=Control, regardless the selection on type field. All other selection in other fields, exept "type", will affect expression result.

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.