topic Comparison of two fields in QlikView

Comparison of two fields

Tue, 19 Apr 2016 08:34:57 GMT

Hi,

I have two different fields which are completely independent. When I click in field one at the value 'A' there should be a field function which excludes the value 'A' in field Two. Another example when I click in the field One on the value B and C, in field Two there must selected everything.

How can i achive that?

Re: Comparison of two fields

swuehl — Tue, 19 Apr 2016 08:37:41 GMT

In general, using field event trigger and selection - select in field actions (go to Settings - Document properties - Triggers).

Your logic is not really clear, could you elaborate on this?

Re: Comparison of two fields

Tue, 19 Apr 2016 08:41:32 GMT

When I choose in field One a Value which is also in field Two,then this value must be excluded in field Two.

One Selection: A Two: D,E

One Selection: C Two: A,D,E

One Selection: B,C Two: A,D,E

Do you understand what I mean?

Re: Comparison of two fields

sunny_talwar — Tue, 19 Apr 2016 08:49:49 GMT

May be like this:

=If(GetSelectedCount(One) > 0, '(' & Concat(DISTINCT {<Two -= P(One)>} Two, '|') & ')')

Re: Comparison of two fields

Mahamed_Qlik — Tue, 19 Apr 2016 08:51:17 GMT

Hi Hans,

If I am not wrong, then you want as below :

If you select A from One then it should exclude A from Two and rest field should get select (D,E)

If you select C from One then A,D,E should get selected .....and like this

Regards,

Mahamed

Re: Comparison of two fields

swuehl — Tue, 19 Apr 2016 08:56:32 GMT

Maybe

=If(GetSelectedCount(One) > 0, '(' & Concat(DISTINCT {1<Two -= P(One)>} Two, '|') & ')')

Re: Comparison of two fields

sunny_talwar — Tue, 19 Apr 2016 08:58:26 GMT

Very nice

Re: Comparison of two fields

Tue, 19 Apr 2016 08:59:24 GMT

Okay try following....

1. Select in field One A, you will become the right result

2. Then select in field One B and C and you will see that in field Two the result is only D and E, but normally we must have A,D,E because A in field One is not selectexd

Re: Comparison of two fields

Tue, 19 Apr 2016 08:59:56 GMT

Exactly!

Re: Comparison of two fields

sunny_talwar — Tue, 19 Apr 2016 09:00:19 GMT

I think Stefan was able to fix that issue. Check out his response

Re: Comparison of two fields

Tue, 19 Apr 2016 09:01:36 GMT

Thank you all for the fast answer! Awesome!