Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Remove a value from a dimension after a selection

Hi all,

I need to remove a specific value from a dimension filter after the selection.

For example: DIM OFFICE = (LONDON,PARIS,ROME)

If I select LONDON in the filter, this value will be excluded from the report in which there's that dimension.

Thank you

1 Reply
settu_periasamy
Master III
Master III

May be you can try with Field Event Trigger. Like

Settings -> Document Properties -> Triggers -> Field Event Triggers ->

Select your Field (DIM OFFICE ) ->  On Select -> Add Actions -> Select Excluded -> Give your Field

Or , in the Chart Expression

=Sum({<[DIM OFFICE]=e([DIM OFFICE])>}Measure)