topic Re: Associate values in one column based on another column. in QlikView

Associate values in one column based on another column.

retko1985 — Wed, 16 May 2018 10:13:45 GMT

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.

Re: Associate values in one column based on another column.

Gysbert_Wassenaar — Wed, 16 May 2018 10:21:11 GMT

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.

Re: Associate values in one column based on another column.

arvind_patil — Wed, 16 May 2018 10:30:15 GMT

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

Re: Associate values in one column based on another column.

retko1985 — Wed, 16 May 2018 11:05:42 GMT

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

Thank you

Re: Associate values in one column based on another column.

Gysbert_Wassenaar — Thu, 17 May 2018 11:29:40 GMT

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

];