Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
APHardeau
Contributor II
Contributor II

Filter not working with specific choice

I'm having an issue where if I select a value in my MaterialProduct filter, it only works on one of the fields.

When selecting HE as the only included value, my top expression returns 0. That makes sense, as it is summing everything that is not RENTAL or HE, so if there's only HE present, there's nothing to sum. If I select everything but HE, both my formulas return results. I don't understand why.

 

Sum({<MProd-={'RENTAL','HE'}>} if([ShpTA]=[ARe],[CMRe]))

Sum({<MProd={'HE'}>} if([ShpTA]=[ARe],[CMRe]))

 

all values.png

 

 

 

 

onlyHE.png

 

 

 

 

all values but HE.png

 

 

Labels (1)
1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

try this

Sum({<MProd*={'HE'}>} if([ShpTA]=[ARe],[CMRe]))

View solution in original post

3 Replies
Chanty4u
MVP
MVP

try this

Sum({<MProd*={'HE'}>} if([ShpTA]=[ARe],[CMRe]))

APHardeau
Contributor II
Contributor II
Author

Wow, thanks! What does the * change to the code?

Chanty4u
MVP
MVP

Great.  it worked !!

@APHardeau 

* means 

This overrides the users selection. Another operator that can be used is Star Equals, this gives the intersection of what is specified in the Set and the users selection.

have a look here 

https://www.quickintelligence.co.uk/qlik-set-analysis-star-equals/