topic Re: Distribute participation in QlikView https://community.qlik.com/t5/QlikView/Distribute-participation/m-p/1435961#M431375 <HTML><HEAD></HEAD><BODY><P>Imediatly I posted the solution came up, here I share it:</P><P></P><P>participation = 1 / AGGR(NODISTINCT COUNT(DISTINCT Owner), Ob_ID)</P><P></P><P>Thanks anyway.-</P></BODY></HTML> Thu, 28 Sep 2017 14:10:25 GMT 2017-09-28T14:10:25Z Distribute participation https://community.qlik.com/t5/QlikView/Distribute-participation/m-p/1435960#M431374 <HTML><HEAD></HEAD><BODY><P>Hi all, </P><P></P><P>I am looking to distribute participation in an object. I have been struggling build this table any clue?</P><P></P><P></P><TABLE border="1" class="jiveBorder" height="244" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="border: 1px solid rgb(0, 0, 0); width: 184px; height: 195px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Ob_ID</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Owner</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P><STRONG>Participation</STRONG></P><P><STRONG>(Expected expression)</STRONG></P></TH></TR><TR><TD style="padding: 2px;">12</TD><TD style="padding: 2px;">Alan</TD><TD style="padding: 2px;">0,33</TD></TR><TR><TD style="padding: 2px;">12</TD><TD style="padding: 2px;">Joan</TD><TD style="padding: 2px;">0,33</TD></TR><TR><TD style="padding: 2px;">12</TD><TD style="padding: 2px;">Laura</TD><TD style="padding: 2px;">0,33</TD></TR><TR><TD style="padding: 2px;">14</TD><TD style="padding: 2px;">Alan</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">15</TD><TD style="padding: 2px;">Sebastian</TD><TD style="padding: 2px;">0,5</TD></TR><TR><TD style="padding: 2px;">15</TD><TD style="padding: 2px;">Laura</TD><TD style="padding: 2px;">0,5</TD></TR></TBODY></TABLE><P></P><P>Thanks in advance.-</P></BODY></HTML> Thu, 28 Sep 2017 13:56:10 GMT https://community.qlik.com/t5/QlikView/Distribute-participation/m-p/1435960#M431374 2017-09-28T13:56:10Z Re: Distribute participation https://community.qlik.com/t5/QlikView/Distribute-participation/m-p/1435961#M431375 <HTML><HEAD></HEAD><BODY><P>Imediatly I posted the solution came up, here I share it:</P><P></P><P>participation = 1 / AGGR(NODISTINCT COUNT(DISTINCT Owner), Ob_ID)</P><P></P><P>Thanks anyway.-</P></BODY></HTML> Thu, 28 Sep 2017 14:10:25 GMT https://community.qlik.com/t5/QlikView/Distribute-participation/m-p/1435961#M431375 2017-09-28T14:10:25Z