Exclude a filter from a particular chart

[mrthomasshelby]

Hello,

I have a stacked bar with 2 measures as in the qvf. Now what I'd like to achieve is stop the filter 'Type' from affecting the bar chart. Can some one please give me the changes I need to make to the expression of the measures? TIA!

[thomaslg_wq]

Hi Phalgun,

You juste have to declare the field you want to stop applying in the measure, so assuming your measure was :

sum(Measure)

It should now be :

sum({<Type>}Measure)

To know more about this, see "set analysis" help : Analyse d'ensembles et expressions d'ensemble ‒ Qlik Sense

[mrthomasshelby]

Hello Thomas. Thanks for the response! But I have already tried this and the thing is my measure has a rather complicated expression. It looks like we need to do something more than what you mentioned. I'd be grateful if you can look into it.

[thomaslg_wq]

Hi again Phalgun,

Well I see in your expression that you're using "conditional expression set analysis" 

like ==> FieldOnWhichFilter={"=condition"} for example for "code" and for "vendor"

But in these conditions you never add the "type" field in set analysis.

Then it has an impact because the measure in condition will be affected by your "type" selection.