Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

stabben23
Honored Contributor

Exclude value from other feild

Field1
10
11
12
13
14
Field2
12
13
14
Final result
10
11

Hi, i have problem to exclude values from an other field. I want to use Field1 as Dimenssion but i want to reduce the Feild with values from Field2. I do need both Fields and this is not a join issue in script. It has to be done in the layout.

1 Solution

Accepted Solutions
MVP
MVP

Re: Exclude value from other feild

Try something like this as dimension:

=aggr(only({<Field1 -= p(Field2) >}Field1),Field1)

2 Replies
MVP
MVP

Re: Exclude value from other feild

Try something like this as dimension:

=aggr(only({<Field1 -= p(Field2) >}Field1),Field1)

stabben23
Honored Contributor

Re: Exclude value from other feild

Thanks for fast and correct answer, use "suppress when value is null" to hide the excluded values value.

Community Browser