topic Re: Exclude value from other feild in QlikView

Exclude value from other feild

stabben23 — Wed, 14 Nov 2012 13:16:32 GMT

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.

Re: Exclude value from other feild

swuehl — Wed, 14 Nov 2012 13:23:49 GMT

Try something like this as dimension:

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

Re: Exclude value from other feild

stabben23 — Wed, 14 Nov 2012 13:33:02 GMT

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