How to solve this logic

[sushil353]

Hi All,

In one of my requirement i want to achieve the result as described below.

I have issues table and component table where a single issue can have multiple components.

Component is in list box and i am calculating count(issues)

Now the requirement is, if a issue has multiple components then it should not included in the count if any of the associated component is not selected.

Say for example if i have data like below

Issue_Key	Component
1	testing
1	testresult
2	roundtest
3	fault

Then if user selects testing and fault then the count(issue_key) should show only 1 count.. since issue_key=1 is also associated with testresult component and that component is not selected, so this issue id is not selected in the result.

I have attached sample application as well.

Please help me to get this resolved.

Thanks

Sushil

[ecolomer]

Hi,

Sorry, you can explain it more.

I do not understand well

Saludos

Enrique Colomer

[ecolomer]

Show this  attached (your file) ...

if you have "component" in selector ...

[tobias_klett]

Hi Sushil,
check this.
Tobias

[JonnyPoole]

Attached is an example that uses  the e() function of SET ANALYSIS. 

{1 <Issue_Key=e({$})>}

May need some more logic for a more complicated scenario but see if its along the right lines..

[evan_kurowski · Accepted solution]

Hello Sushil,

This app should fit your criteria.  If only a partial list of an Issue_Key's associated Components are in selection, that Issue_Key doesn't render in the chart.  Only once a full list of that Issue_Key's associated Components are in selection/possible, will it make the chart dimension and tabulate.

[sushil353]

Thanks Evan,

I think your solution is very close to mine.. let me use this into my real situation..

will keep u posted.

Thanks again.