Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning guys.
I am using qlik sense and I have an issue preventing filters from effecting values.
I have four filters.
Selection1, Selection2, Selection3, and Control4 (They are all dimension feilds)
I have a measure called MeasureA. MeasureA is represented as SUM(distinct MeasureA)
When I make a selection to Control 4 I want Measure A filtered.
When I make a Selection to 1,2, or 3, I do NOT want MeasureA to be filtered.
I also don't want Selection 1,2, or 3 to filter Control4.
How do I accomplish this
@Mdjenkins wrote:I need to figure out how to get one filter to ignore another filter.
So, then this is not about KPI... you can do this by amending your data or using alternate state. For more help please provide a sample so that we can see what you already have and guide you in the right direction.
I may be missing some complexity here, but it sounds like you just want to ignore selections in 1,2,3?
SUM({<Control1=, Control2=, Control3=>}distinct MeasureA)
-Rob
I'd suggest setting up a copy of Control4 as a new field in an island table and present it to the user as the filter.
The expression would be something like:
Sum(DISTINCT {<Control4 = p(NewField),Selection1, Selection2, Selection3>} MeasureA)