topic Re: How to create Union between two dimensions? in QlikView

How to create Union between two dimensions?

Mon, 11 Feb 2013 06:27:09 GMT

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

Re: How to create Union between two dimensions?

phaneendra_kunc — Mon, 11 Feb 2013 06:36:04 GMT

See if the attached helps..

Phani

Re: How to create Union between two dimensions?

Mon, 11 Feb 2013 06:43:51 GMT

try it

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

Re: How to create Union between two dimensions?

Mon, 11 Feb 2013 06:56:34 GMT

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