topic Find common values in a field based on other field in QlikView

Find common values in a field based on other field

Fri, 26 Jul 2013 12:02:24 GMT

Hi,

I have two fields, consider field1 and field2.

Field1 has two values 0 and 1.

Field2 has values like A,B,C,D,E,F,G.

These two fields are related to each other, if i select 0 from field1, it will filter A,B,C,D.

if i select 1 from field1, it will filter everything in field2 means A,B,C,D,E,F,G.

Now i want to get the common values between these selections. i.e., A,B,C,D

i want to get the common values in other listbox which should show A,B,C,D.

How can we get that?

Gysbert_Wassenaar — Fri, 26 Jul 2013 13:01:50 GMT

Fri, 26 Jul 2013 13:02:10 GMT

bydefault our selection of listbox work on union. if you want to work on intersection then must be used And mode option.

for this

simply load your table in script with Distinct keyword.

then right clik on the field1 and in general check the And mode option the select o and1 then your common field are selected in field2.

see attachement

Mon, 29 Jul 2013 09:52:05 GMT

Now, I want to get E,F,G as a value in the listbox always.

It should not change even if we make any selections.

How can we get?

get excluded values, which is present in when field1=1, but not in field1=0.