Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Re: Remove a value from a dimension after a selection

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)

Community Browser