topic count distinct in QlikView https://community.qlik.com/t5/QlikView/count-distinct/m-p/931509#M321996 <HTML><HEAD></HEAD><BODY><P>Hey expert:</P><P></P><P>I need your help in a calculation. Somewhow I am not getting the right result. Please look at the table below. I want to calculate the<STRONG> count of distinct container which has both the Leg Type- SIngle leg and Multi leg</STRONG>. In below table it should be 2 as Containr B500 and A503 have both <SPAN style="font-size: 13.3333330154419px;">Single leg and Multi leg.</SPAN></P><P></P><P>&nbsp;&nbsp; </P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="211"><TBODY><TR><TD class="xl64" height="20" width="132">Container Number</TD><TD class="xl64" style="border-left: none;" width="79">Leg Type</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">B500</TD><TD class="xl64" style="border-top: none; border-left: none;">Single leg</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">B500</TD><TD class="xl64" style="border-top: none; border-left: none;">Multi leg</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">A500</TD><TD class="xl64" style="border-top: none; border-left: none;">Single leg</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">C501</TD><TD class="xl64" style="border-top: none; border-left: none;">Multi leg</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">A500</TD><TD class="xl64" style="border-top: none; border-left: none;">Single leg</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">A503</TD><TD class="xl64" style="border-top: none; border-left: none;">Multi leg</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">A503</TD><TD class="xl64" style="border-top: none; border-left: none;">Single leg</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">A503</TD><TD class="xl64" style="border-top: none; border-left: none;">Single leg</TD></TR></TBODY></TABLE><P></P><P></P><P>Any help is much appreciated.</P></BODY></HTML> Fri, 28 Aug 2015 20:37:46 GMT Anonymous 2015-08-28T20:37:46Z count distinct https://community.qlik.com/t5/QlikView/count-distinct/m-p/931509#M321996 <HTML><HEAD></HEAD><BODY><P>Hey expert:</P><P></P><P>I need your help in a calculation. Somewhow I am not getting the right result. Please look at the table below. I want to calculate the<STRONG> count of distinct container which has both the Leg Type- SIngle leg and Multi leg</STRONG>. In below table it should be 2 as Containr B500 and A503 have both <SPAN style="font-size: 13.3333330154419px;">Single leg and Multi leg.</SPAN></P><P></P><P>&nbsp;&nbsp; </P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="211"><TBODY><TR><TD class="xl64" height="20" width="132">Container Number</TD><TD class="xl64" style="border-left: none;" width="79">Leg Type</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">B500</TD><TD class="xl64" style="border-top: none; border-left: none;">Single leg</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">B500</TD><TD class="xl64" style="border-top: none; border-left: none;">Multi leg</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">A500</TD><TD class="xl64" style="border-top: none; border-left: none;">Single leg</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">C501</TD><TD class="xl64" style="border-top: none; border-left: none;">Multi leg</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">A500</TD><TD class="xl64" style="border-top: none; border-left: none;">Single leg</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">A503</TD><TD class="xl64" style="border-top: none; border-left: none;">Multi leg</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">A503</TD><TD class="xl64" style="border-top: none; border-left: none;">Single leg</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">A503</TD><TD class="xl64" style="border-top: none; border-left: none;">Single leg</TD></TR></TBODY></TABLE><P></P><P></P><P>Any help is much appreciated.</P></BODY></HTML> Fri, 28 Aug 2015 20:37:46 GMT https://community.qlik.com/t5/QlikView/count-distinct/m-p/931509#M321996 Anonymous 2015-08-28T20:37:46Z Re: count distinct https://community.qlik.com/t5/QlikView/count-distinct/m-p/931510#M321997 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>solutions might be:</P><P></P><P><IMG alt="QlikCommunity_Thread_178370_Pic1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/97318_QlikCommunity_Thread_178370_Pic1.JPG" style="height: 190px; width: 620px;" /></P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Fri, 28 Aug 2015 21:41:22 GMT https://community.qlik.com/t5/QlikView/count-distinct/m-p/931510#M321997 MarcoWedel 2015-08-28T21:41:22Z