Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]))
try this
Sum({<MProd*={'HE'}>} if([ShpTA]=[ARe],[CMRe]))
Wow, thanks! What does the * change to the code?
Great. it worked !!
* 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/