Need Help on Pivot/Straight table for the below Requirement

Anonymous — Tue, 19 May 2015 13:52:48 GMT

Hi All,

I have Source data, based on that I wanna split that data into two report i.e., Report-1, Report-2 as show below.

Please post the answer as soon as possible.

Source-Data:

Model	Role	Specialization
APJ	Role-1	ABC
EMEA	Role-1	ABC
APJ	Role-2	XYZ
EMAR	Role-2	XYZ
US	Role-2	XYZ
US	Role-3	MNO
APJ	Role-4	PQR
EMAR	Role-4	PQR
US	Role-4	EFG

Report-1; (Hints: Split data based on Role. here for each Region Specialization will be same. here for Role-4 specializations are not same, if this is the case we have to skip that role.

Simply to say: here we are displaying data in the report for each role which is having same specialization)

Role	Specialization	APJ	EMEA	US
Role-1	ABC	Yes	Yes	No
Role-2	XYZ	Yes	Yes	Yes
Role-3	MNO	No	No	Yes

Report-2:

(Hints: this is the data which is having different specializations for the same role)

Model	Role	Specialization
APJ	Role-4	PQR
EMAR	Role-4	PQR
US	Role-4	EFG

Can any one let me know the logic, and if possible attach the solution.qvw.

Note: "Source-Data" sheet contains the Source data for this requirement as attached.

Thanks,

Ravi

topic Need Help on Pivot/Straight table for the below Requirement in QlikView

Need Help on Pivot/Straight table for the below Requirement