topic Re: How many dependants does 'AB1' have in QlikView https://community.qlik.com/t5/QlikView/How-many-dependants-does-AB1-have/m-p/842405#M993413 <HTML><HEAD></HEAD><BODY><P>Seems to be working as Manish prescribed:</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/92414_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 09 Jul 2015 14:59:53 GMT sunny_talwar 2015-07-09T14:59:53Z How many dependants does 'AB1' have https://community.qlik.com/t5/QlikView/How-many-dependants-does-AB1-have/m-p/842401#M993405 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I will try an explain what I am trying to do:</P><P></P><P>Field A&nbsp;&nbsp;&nbsp; Field B</P><P>AB1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DE</P><P>AB2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DE</P><P>AB3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DE</P><P>AB4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DE</P><P>AB3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FG</P><P></P><P>AB1,AB2,AB4,AB5 has 1 dependant</P><P>Where as</P><P>AB3 has 2</P><P></P><P>How can I write an expression to find this out?</P><P></P><P>Thanks</P></BODY></HTML> Thu, 09 Jul 2015 14:42:59 GMT https://community.qlik.com/t5/QlikView/How-many-dependants-does-AB1-have/m-p/842401#M993405 tinkerz1 2015-07-09T14:42:59Z Re: How many dependants does 'AB1' have https://community.qlik.com/t5/QlikView/How-many-dependants-does-AB1-have/m-p/842402#M993407 <HTML><HEAD></HEAD><BODY><P>Create a Straight Table</P><P>Dimension</P><P>[Field A<SPAN style="font-size: 10pt; line-height: 1.5em;">]</SPAN></P><P>Expression</P><P>Count(Distinct [Field B])</P></BODY></HTML> Thu, 09 Jul 2015 14:46:02 GMT https://community.qlik.com/t5/QlikView/How-many-dependants-does-AB1-have/m-p/842402#M993407 MK_QSL 2015-07-09T14:46:02Z Re: How many dependants does 'AB1' have https://community.qlik.com/t5/QlikView/How-many-dependants-does-AB1-have/m-p/842403#M993409 <HTML><HEAD></HEAD><BODY><P>Sorry,</P><P></P><P>That does not produce any data, it should produce</P><P>AB1&nbsp;&nbsp; 1</P><P>AB2&nbsp;&nbsp; 1</P><P>AB3&nbsp;&nbsp; 2</P><P></P><P>Many Thanks</P></BODY></HTML> Thu, 09 Jul 2015 14:55:20 GMT https://community.qlik.com/t5/QlikView/How-many-dependants-does-AB1-have/m-p/842403#M993409 tinkerz1 2015-07-09T14:55:20Z Re: How many dependants does 'AB1' have https://community.qlik.com/t5/QlikView/How-many-dependants-does-AB1-have/m-p/842404#M993411 <HTML><HEAD></HEAD><BODY><P>Manish is correct:</P><P></P><P><IMG alt="09-Jul-15 3-58-43 PM.jpg" class="jive-image image-1" src="/legacyfs/online/92412_09-Jul-15 3-58-43 PM.jpg" style="height: 386px; width: 620px;" /></P></BODY></HTML> Thu, 09 Jul 2015 14:59:26 GMT https://community.qlik.com/t5/QlikView/How-many-dependants-does-AB1-have/m-p/842404#M993411 robert_mika 2015-07-09T14:59:26Z Re: How many dependants does 'AB1' have https://community.qlik.com/t5/QlikView/How-many-dependants-does-AB1-have/m-p/842405#M993413 <HTML><HEAD></HEAD><BODY><P>Seems to be working as Manish prescribed:</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/92414_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 09 Jul 2015 14:59:53 GMT https://community.qlik.com/t5/QlikView/How-many-dependants-does-AB1-have/m-p/842405#M993413 sunny_talwar 2015-07-09T14:59:53Z