Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
sarfaraz_sheikh
Contributor III
Contributor III

Build connectivity in set analysis

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

       

FindIDTreatDSourceIDTypeLevelTitleAssetIDCountKey
ITRC\Break\1Unspecified1BreakFindingTest Break 11234ITRC\Break\1
ITRC\Break\1ITRC\Remedy\11RemedyTreatmentTest Remedy 11234ITRC\Remedy\1
ITRC\Break\2Unspecified2BreakFindingTest Break 23456ITRC\Break\2
ITRC\Break\2ITRC\Remedy\11RemedyTreatmentTest Remedy  13456ITRC\Remedy\1
SEAL\SEALDQ\1SEAL\SEALDQ\11SEAL DQTreatmentTest SEAL DQ 11234SEAL\SEALDQ\1
ITRC\ACA\1ITRC\ACA\11ACATreatmentTest ACA 11234ITRC\ACA\1
FORCE\Issue\1Unspecified1IssueFindingTest Issue 1FORCE\Issue\1
FORCE\Issue\1FORCE\Action Plan\11Action PlanTreatmentTest Action Plan 1FORCE\Action Plan\1
FORCE\Issue\1FORCE\Action Plan\22Action PlanTreatmentTest Action Plan 2FORCE\Action Plan\2
FORCE\Issue\1FORCE\Action Plan\33Action PlanTreatmentTest Action Plan 3FORCE\Action Plan\3
FORCE\Issue\2Unspecified2IssueFindingTest Issue 1FORCE\Issue\2
FORCE\Issue\2FORCE\Risk Acceptance\11Risk AcceptanceTreatmentTest Risk Acceptance 1FORCE\Risk Acceptance\1
ITRC\Break\3Unspecified3BreakFindingTest Break 37890ITRC\Break\3
ITRC\Break\3ITRC\Remedy\22RemedyTreatmentTest Remedy 27890ITRC\Remedy\2
FORCE\Issue\3Unspecified3IssueFindingTest Issue 37890FORCE\Issue\3
FORCE\Issue\3FORCE\Risk Acceptance\22Risk AcceptanceTreatmentTest Risk Acceptance 2FORCE\Risk Acceptance\2

I want below output

   

TestCase1Select BreakID = 1
TypeSourceIDTitle
Break1Test Break 1
Remedy1Test Remedy 1
SEAL DQ1Test SEAL DQ 1
ACA1Test ACA 1
Break2Test Break 2
Application1234My App Name

Test case 2

   

TypeSourceIDTitle
Break3Test Break 3
Remedy2Test Remedy 2
Issue3Test Issue 3
Risk Acceptance2Test Risk Acceptance 2
Application7890My App Name
0 Replies