How to create Union between two dimensions?

[#1]

I have two dimensions in a pivot table with similar kind of data.

A          B

S02     S02

S02     S03

S03     S03

S07     S07    

S07     S02

when selection is made on  listbox 'A' for 'S02'

I want

A          B

S02     S02

S02     S03

S07     S02

Result set.

Please Help.

Best Regards,

Gaurav Tyagi

[phaneendra_kunc]

See if the attached helps..

Phani

[#3]

hi

try it

a:

LOAD * INLINE [

    A, B

    S02, S02

    S02, S03

    S03, S03

    S07, S07

    S07, S02

];

Concatenate

LOAD B as A,

     A as B

Resident a;

when you select S02 on listboxA:--

then output like this

A	B
S02	S02
S02	S03
S02	S07

[#4]

Hi Ranjan,

I want Union in the resulting tables not in the list boxes.

Your code is doing the union in the list boxes but not giving me the desired result set as I have mentioned in my query above. Thanks for your help though, Still working on it.

Hi Phani not able to open your documents on my machine I'm using the free version of QlikView.

Thanks,

Gaurav Tyagi