Choosing filter from another chart will not effect certain measures of another chart

[Zaidan_as]

Hello qlik experts,

as i mention in title, I want certain measures in chart A, will not be effected when I choose filter/data from chart B. 

The illustration is like this, 

I have this Chart B, that showing the data per NC_Detail

When I choose the first bar, it will be selected as filter by qlik sense, the illustration is like this

Now, I want this NC_Detail, all of it data, doesn't effected certain measures in another chart, 
Im using this formula for the measures,
SUM( AGGR(SUM(DISTINCT Inspection_Qty), EPLotNo))

I already implemented this expression,
SUM({<[NC_Detail]=>} AGGR(SUM(DISTINCT Inspection_Qty), EPLotNo))

but it still effected this measure when the NC_Detail is chosen as filter. 

Is there any solution ?

[Patricia_Silva]

Hello @Zaidan_as, have you tried with Alternate States? https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/Visualizations/alter...

[Digvijay_Singh · Accepted solution]

Alternate state can help but if its just one dimension you want to disregard, probably you missed to add that in other SUM function and it may work like this, not sure though without actually trying on the app - 

SUM({<[NC_Detail]=>} AGGR(SUM(<[NC_Detail]=>}  DISTINCT Inspection_Qty), EPLotNo))

[Zaidan_as]

Hello @Digvijay_Singh Thanks for the answer,

Unfortunately, when I using your expression, all of the value (the AC Qty pcs) become zero.

[Zaidan_as]

Hello @Patricia_Silva thanks for the information, 
I will try to study it first

[Zaidan_as]

@Digvijay_Singh 
Okay, i notice something, 
In your expression, you miss one "{" on the second sum function. Then when I try it again using your expression + add the "{", it worked fine. I will accept your solution. Thank you so much for the answer again.

So overall, this is the code. 
SUM({<NC_Detail=>}AGGR(SUM({<NC_Detail=>}DISTINCT Inspection_Qty)