Find number of connected items

[Murtuza]

Hello Everyone, 

I am quite new to Qlik, and have a problem in hand.

I have my input raw data in the below tables.

Requirement	Requirement ID	Section
Req-1	R1	S1
Req-2	R2	S1
Req-3	R3	S2
Req-4	R4	S3
Req-5	R5	S3
Req-6	R6	S3
Req-7	R7	S4
Requirement ID	Test Case ID	Test Case Name
R1	T1	Test Case Name1
R1	T2	Test Case Name2
R1	T3	Test Case Name3
R1	T4	Test Case Name4
R2	T5	Test Case Name5
R2	T6	Test Case Name6
R2	T7	Test Case Name7
R2	T8	Test Case Name8
R3	T9	Test Case Name9
R4	T10	Test Case Name10
R4	T11	Test Case Name11
R4	T12	Test Case Name12
R5	T13	Test Case Name13

What I am trying to achieve is statistics around 3 things

1. What is the percentage of linked requirements in each section?

Section	Percentage Covered
S1	100
S2	100
S3	66
S4	0

For example, S1 has 2 requirements, both of them have linked test cases to it.

S3 has 3 requirements, and out of this 2 have linked test cases, so 66 percent.

Any help on how to represent this on a table or a stacked bar chart would be much appreciated.

[Brett_Bleess]

The best I have for you is to check out the Design Blog are of the Community, this is where our internal experts have posted over 700 posts mostly related to how-to scenarios, so you may find something to help there.  Other than that, the best I can guide is to also search prior community posts for similar issues that have posted solutions too, as I am fairly certain there are some out here that should be helpful too.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Base area of Community from which to search for prior posts:

https://community.qlik.com/t5/QlikView/ct-p/qlikview

Sorry I do not have anything better for you, this post will kick things back up, so someone else may offer up some more concrete thoughts too, but no promises.  The main issue I see in someone helping, is you did not go into detail as to how the percentage is determined either, which is likely one reason nobody has answered previously.

Regards,
Brett