topic Re: How to solve this logic in QlikView

How to solve this logic

sushil353 — Wed, 06 Aug 2014 17:45:28 GMT

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

Re: How to solve this logic

ecolomer — Wed, 06 Aug 2014 18:17:51 GMT

Hi,

Sorry, you can explain it more.

I do not understand well

Saludos

Enrique Colomer

Re: How to solve this logic

ecolomer — Wed, 06 Aug 2014 18:21:02 GMT

Show this attached (your file) ...

if you have "component" in selector ...

Re: How to solve this logic

tobias_klett — Wed, 06 Aug 2014 18:32:07 GMT

Hi Sushil,
check this.
Tobias

Re: How to solve this logic

JonnyPoole — Wed, 06 Aug 2014 18:32:41 GMT

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..

Re: How to solve this logic

evan_kurowski — Wed, 06 Aug 2014 18:33:36 GMT

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.

Re: How to solve this logic

sushil353 — Wed, 06 Aug 2014 18:49:51 GMT

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.