topic Remove a value from a dimension after a selection in QlikView

Remove a value from a dimension after a selection

Fri, 12 Feb 2016 10:06:39 GMT

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

settu_periasamy — Tue, 16 Feb 2016 02:48:35 GMT

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)