topic Re: How to count a field which has a common value with other fields? in QlikView https://community.qlik.com/t5/QlikView/How-to-count-a-field-which-has-a-common-value-with-other-fields/m-p/94010#M510671 <HTML><HEAD></HEAD><BODY><P>yes, correct!</P></BODY></HTML> Mon, 06 Aug 2018 11:30:08 GMT Anonymous 2018-08-06T11:30:08Z How to count a field which has a common value with other fields? https://community.qlik.com/t5/QlikView/How-to-count-a-field-which-has-a-common-value-with-other-fields/m-p/94003#M510657 <HTML><HEAD></HEAD><BODY><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/209537_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P>In the above table, the value "ADAPTER" in ITEM NAME field is a common value for both "VO" and "PTO" of DIV field.</P><P></P><P>I want to count how many such values in ITEM NAME has the same characteristic.</P><P></P><P>Please assist.</P></BODY></HTML> Wed, 01 Aug 2018 11:20:30 GMT https://community.qlik.com/t5/QlikView/How-to-count-a-field-which-has-a-common-value-with-other-fields/m-p/94003#M510657 Anonymous 2018-08-01T11:20:30Z Re: How to count a field which has a common value with other fields? https://community.qlik.com/t5/QlikView/How-to-count-a-field-which-has-a-common-value-with-other-fields/m-p/94004#M510659 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Count(DISTINCT {&lt;[ITEM NAME] = {"=Count(DISTINCT DIV) &gt; 1"}&gt;} [ITEM NAME])</STRONG></P></BODY></HTML> Wed, 01 Aug 2018 11:25:46 GMT https://community.qlik.com/t5/QlikView/How-to-count-a-field-which-has-a-common-value-with-other-fields/m-p/94004#M510659 sunny_talwar 2018-08-01T11:25:46Z Re: How to count a field which has a common value with other fields? https://community.qlik.com/t5/QlikView/How-to-count-a-field-which-has-a-common-value-with-other-fields/m-p/94005#M510661 <HTML><HEAD></HEAD><BODY><P><STRONG>shall I use this same as it is ?</STRONG></P><P></P><P><STRONG>or I have to enter the values like "PTO" and "VO" anywhere ?</STRONG></P></BODY></HTML> Wed, 01 Aug 2018 11:40:33 GMT https://community.qlik.com/t5/QlikView/How-to-count-a-field-which-has-a-common-value-with-other-fields/m-p/94005#M510661 Anonymous 2018-08-01T11:40:33Z Re: How to count a field which has a common value with other fields? https://community.qlik.com/t5/QlikView/How-to-count-a-field-which-has-a-common-value-with-other-fields/m-p/94006#M510663 <HTML><HEAD></HEAD><BODY><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Count(DISTINCT {&lt;[ITEM NAME = {'=Count(DISTINCT DIV) &gt; 1'}]&gt;} [ITEM NAME])</STRONG></P></BODY></HTML> Wed, 01 Aug 2018 11:42:37 GMT https://community.qlik.com/t5/QlikView/How-to-count-a-field-which-has-a-common-value-with-other-fields/m-p/94006#M510663 arvind1494 2018-08-01T11:42:37Z Re: How to count a field which has a common value with other fields? https://community.qlik.com/t5/QlikView/How-to-count-a-field-which-has-a-common-value-with-other-fields/m-p/94007#M510665 <HTML><HEAD></HEAD><BODY><P>Just try it as is</P></BODY></HTML> Wed, 01 Aug 2018 11:46:47 GMT https://community.qlik.com/t5/QlikView/How-to-count-a-field-which-has-a-common-value-with-other-fields/m-p/94007#M510665 sunny_talwar 2018-08-01T11:46:47Z Re: How to count a field which has a common value with other fields? https://community.qlik.com/t5/QlikView/How-to-count-a-field-which-has-a-common-value-with-other-fields/m-p/94008#M510667 <HTML><HEAD></HEAD><BODY><P>it is giving distinct count value for each ITEM NAME.</P><P></P><P>I need count for each ITEM NAME value having "VO" and "PTO" in DIV field.</P><P></P><P>Eg; For the above table, the count value for "adapter" should be one and the same for "actuator" as well.</P></BODY></HTML> Wed, 01 Aug 2018 12:45:31 GMT https://community.qlik.com/t5/QlikView/How-to-count-a-field-which-has-a-common-value-with-other-fields/m-p/94008#M510667 Anonymous 2018-08-01T12:45:31Z Re: How to count a field which has a common value with other fields? https://community.qlik.com/t5/QlikView/How-to-count-a-field-which-has-a-common-value-with-other-fields/m-p/94009#M510669 <HTML><HEAD></HEAD><BODY><P>I am not sure I follow... is this what you want?</P><P></P><P>Dimension&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value</P><P>ADAPTER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>ACTUATOR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P></BODY></HTML> Wed, 01 Aug 2018 12:58:26 GMT https://community.qlik.com/t5/QlikView/How-to-count-a-field-which-has-a-common-value-with-other-fields/m-p/94009#M510669 sunny_talwar 2018-08-01T12:58:26Z Re: How to count a field which has a common value with other fields? https://community.qlik.com/t5/QlikView/How-to-count-a-field-which-has-a-common-value-with-other-fields/m-p/94010#M510671 <HTML><HEAD></HEAD><BODY><P>yes, correct!</P></BODY></HTML> Mon, 06 Aug 2018 11:30:08 GMT https://community.qlik.com/t5/QlikView/How-to-count-a-field-which-has-a-common-value-with-other-fields/m-p/94010#M510671 Anonymous 2018-08-06T11:30:08Z Re: How to count a field which has a common value with other fields? https://community.qlik.com/t5/QlikView/How-to-count-a-field-which-has-a-common-value-with-other-fields/m-p/94011#M510673 <HTML><HEAD></HEAD><BODY><P>I used this expression</P><P><STRONG>Count(DISTINCT {&lt;[ITEM NAME] = {"=Count(DISTINCT DIV) &gt; 1"}&gt;} [ITEM NAME])</STRONG></P><P></P><P>and got this</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/209951_Capture.PNG" style="height: 107px; width: 620px;" /></P><P></P><P>What is wrong?</P></BODY></HTML> Mon, 06 Aug 2018 11:38:12 GMT https://community.qlik.com/t5/QlikView/How-to-count-a-field-which-has-a-common-value-with-other-fields/m-p/94011#M510673 sunny_talwar 2018-08-06T11:38:12Z Re: How to count a field which has a common value with other fields? https://community.qlik.com/t5/QlikView/How-to-count-a-field-which-has-a-common-value-with-other-fields/m-p/94012#M510675 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny and Arvind.. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P></BODY></HTML> Mon, 06 Aug 2018 13:30:47 GMT https://community.qlik.com/t5/QlikView/How-to-count-a-field-which-has-a-common-value-with-other-fields/m-p/94012#M510675 Anonymous 2018-08-06T13:30:47Z