Qlik change measures to dimension

[harikattamudi]

Dear Experts,

I have the data structured as below in 2 different tables 

Table1
Sales Order	Cluster
SO1	C1
SO2	C2
SO3	C1

Table2
Sales Order	materials
SO1
	A
	B
	C
SO2
	A
	B
	C
	D
	M
SO3
	A
	D
	E
	F
	G

After loading the data, I’m getting the output as below

Cluster	Materials
C1	A
	B
	C
	D
	E
	F
	G
C2	A
	B
	C
	D

But I’m looking for output to be something like this.

Cluster	Materials
Just C1	E
	F
	G
Just C2	M
C1&C2	A
	B
	C
	D

Cluster	Count of Materials
Just C1	3
Just C2	1
C1&C2	4

Can someone please help me here.

Thanks for your support.

-Raghava

[swapniltaz]

What is you are looking for is Intersection of Data .

You can archive the same using Set Analysis at the Layout Level .

[harikattamudi]

Hello Swapniltaz,
Can you be more specific please. How should the set analysis statement look like?