Build connectivity in set analysis

sarfaraz_sheikh — Fri, 07 Sep 2018 14:08:41 GMT

Hi Folks,

I have below data and i want to show the records based on selection ..so suppose if i select break1 from find ID then i will come to know what are the TreatID and AssetID related to that particular selected break ...and what are the associated items for TreatID and AssetID for selected break 1.

You can see what i want in output below as test cases. How to achive this.

help would be much appreciable. Thanks

FindID	TreatD	SourceID	Type	Level	Title	AssetID	CountKey
ITRC\Break\1	Unspecified	1	Break	Finding	Test Break 1	1234	ITRC\Break\1
ITRC\Break\1	ITRC\Remedy\1	1	Remedy	Treatment	Test Remedy 1	1234	ITRC\Remedy\1
ITRC\Break\2	Unspecified	2	Break	Finding	Test Break 2	3456	ITRC\Break\2
ITRC\Break\2	ITRC\Remedy\1	1	Remedy	Treatment	Test Remedy 1	3456	ITRC\Remedy\1
SEAL\SEALDQ\1	SEAL\SEALDQ\1	1	SEAL DQ	Treatment	Test SEAL DQ 1	1234	SEAL\SEALDQ\1
ITRC\ACA\1	ITRC\ACA\1	1	ACA	Treatment	Test ACA 1	1234	ITRC\ACA\1
FORCE\Issue\1	Unspecified	1	Issue	Finding	Test Issue 1	FORCE\Issue\1
FORCE\Issue\1	FORCE\Action Plan\1	1	Action Plan	Treatment	Test Action Plan 1	FORCE\Action Plan\1
FORCE\Issue\1	FORCE\Action Plan\2	2	Action Plan	Treatment	Test Action Plan 2	FORCE\Action Plan\2
FORCE\Issue\1	FORCE\Action Plan\3	3	Action Plan	Treatment	Test Action Plan 3	FORCE\Action Plan\3
FORCE\Issue\2	Unspecified	2	Issue	Finding	Test Issue 1	FORCE\Issue\2
FORCE\Issue\2	FORCE\Risk Acceptance\1	1	Risk Acceptance	Treatment	Test Risk Acceptance 1	FORCE\Risk Acceptance\1
ITRC\Break\3	Unspecified	3	Break	Finding	Test Break 3	7890	ITRC\Break\3
ITRC\Break\3	ITRC\Remedy\2	2	Remedy	Treatment	Test Remedy 2	7890	ITRC\Remedy\2
FORCE\Issue\3	Unspecified	3	Issue	Finding	Test Issue 3	7890	FORCE\Issue\3
FORCE\Issue\3	FORCE\Risk Acceptance\2	2	Risk Acceptance	Treatment	Test Risk Acceptance 2	FORCE\Risk Acceptance\2

I want below output

TestCase1	Select BreakID = 1
Type	SourceID	Title
Break	1	Test Break 1
Remedy	1	Test Remedy 1
SEAL DQ	1	Test SEAL DQ 1
ACA	1	Test ACA 1
Break	2	Test Break 2
Application	1234	My App Name

Test case 2

Type	SourceID	Title
Break	3	Test Break 3
Remedy	2	Test Remedy 2
Issue	3	Test Issue 3
Risk Acceptance	2	Test Risk Acceptance 2
Application	7890	My App Name

topic Build connectivity in set analysis in QlikView

Build connectivity in set analysis