Associate values in one column based on another column.

[retko1985]

Hello,

here are my example data:

AAA belongs to key1 = 1, and also BBB belongs to the same key1 = 1.

So, I created 2 listboxes with this expression as a field:

first:

=if(key2 = 'A', some_dim_value)

second:

=if(key2 = 'B', some_dim_value)

Now, when I select AAA, I want BBB to be white (associated, because both of them belong to the same key1).

Is it possible?

Probably by changing model?

Attaching qvw.

Thank you.

[Gysbert_Wassenaar]

AAA and BBB are values in the same field. It's not possible to select a value in a field and also have the other values in the same field shown in white as possible values. You'll have to split the data into two tables that only have the field key1 in common. The other fields need to have different names in the two tables.

[arvind_patil]

Hi Retko,

The association is not possible because both values(AAA,BBB) in same field.

in this case you are selecting list granularity data rather than selecting AAA select Key1 it shows Both .

Thanks,

Arvind Patil

[retko1985]

Hi, thank you... I was thinking about splitting, but cant come up with it. Can you please elaborate more??

Thank you

[Gysbert_Wassenaar]

Like this:

LOAD * INLINE [

    key1, key2_a, some_dim_value_a, surrogate_Key_a

    1, A, AAA, 1

    1, A, AAA, 2

    1, A, AAA, 3

    1, A, AAA, 4

    1, A, AAA, 5

    1, A, AAA, 6

];

LOAD * INLINE [

    key1, key2_b, some_dim_value_b, surrogate_Key_b

    1, B, BBB, 7

    1, B, BBB, 8

    1, B, BBB, 9

    1, B, BBB, 10

    1, B, BBB, 11

    1, B, BBB, 12

];