Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
sureshmaddipati
Contributor III
Contributor III

Pick match is not excluding selection

I have filter month_quarter  which I want exclude from pivot table 

The present expression is as below.

Pick(match(dimension, 'RWA'),

Num(sum({<mica={'RWA'},month_quarter=>}.

Used alternate state and grouping still not working please help me with appropriate approach

Labels (2)
2 Replies
TauseefKhan
Creator III
Creator III

To calculates the sum of YourMetric where mica is RWA, ignoring any selections made on month_quarter.

Pick(match(dimension, 'RWA'),
Num(sum({<mica={'RWA'}, month_quarter=>} [YourMetric])))


****Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.****

sureshmaddipati
Contributor III
Contributor III
Author

My bad missed to ad my metric

But still the issue remains same