Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Zaidan_as
Creator
Creator

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

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

Zaidan_as_0-1648029720435.png

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

Zaidan_as_1-1648029760902.png

Zaidan_as_2-1648029769635.png

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 ?

 

Labels (5)
1 Solution

Accepted Solutions
Digvijay_Singh

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))

View solution in original post

5 Replies
Patricia_Silva
Specialist II
Specialist II

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

Help users find answers! Don't forget to mark a correct resolution 🙂
Digvijay_Singh

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
Creator
Creator
Author

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_0-1648080795913.png

 

Zaidan_as
Creator
Creator
Author

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

 

Zaidan_as
Creator
Creator
Author

@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)