topic Re: Counting Distinct values and separating into 3 columns in QlikView https://community.qlik.com/t5/QlikView/Counting-Distinct-values-and-separating-into-3-columns/m-p/355246#M493083 <HTML><HEAD></HEAD><BODY><P>Like a charm.&nbsp; Thanks!</P></BODY></HTML> Fri, 15 Jun 2012 14:47:17 GMT 2012-06-15T14:47:17Z Counting Distinct values and separating into 3 columns https://community.qlik.com/t5/QlikView/Counting-Distinct-values-and-separating-into-3-columns/m-p/355244#M493081 <HTML><HEAD></HEAD><BODY><P>Hi-</P><P></P><P>I have a straight table that I am looking to show total counts of the # of documents associated with a certain type of "document type".</P><P></P><P>I tried using =if(DocType = 'DocTypeA', count(distinct(DocID))) for the first DocType expression, and substituted 'DocTypeB' and 'DocTypeC' for the other two expressions.</P><P></P><P>In some cases, it is working, but in cases that the 'Person' (my dimension) has multiple 'document types' , it will only show the first expression total.&nbsp; </P><P></P><P>Is this a problem that set analysis can solve?</P></BODY></HTML> Fri, 15 Jun 2012 14:16:03 GMT https://community.qlik.com/t5/QlikView/Counting-Distinct-values-and-separating-into-3-columns/m-p/355244#M493081 2012-06-15T14:16:03Z Re: Counting Distinct values and separating into 3 columns https://community.qlik.com/t5/QlikView/Counting-Distinct-values-and-separating-into-3-columns/m-p/355245#M493082 <HTML><HEAD></HEAD><BODY><P>try count(distinct {$&lt;[<SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">DocType</SPAN>]={"<SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">DocTypeA</SPAN>"}&gt;} [<SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">DocID</SPAN>])</P></BODY></HTML> Fri, 15 Jun 2012 14:35:09 GMT https://community.qlik.com/t5/QlikView/Counting-Distinct-values-and-separating-into-3-columns/m-p/355245#M493082 giakoum 2012-06-15T14:35:09Z Re: Counting Distinct values and separating into 3 columns https://community.qlik.com/t5/QlikView/Counting-Distinct-values-and-separating-into-3-columns/m-p/355246#M493083 <HTML><HEAD></HEAD><BODY><P>Like a charm.&nbsp; Thanks!</P></BODY></HTML> Fri, 15 Jun 2012 14:47:17 GMT https://community.qlik.com/t5/QlikView/Counting-Distinct-values-and-separating-into-3-columns/m-p/355246#M493083 2012-06-15T14:47:17Z Re: Counting Distinct values and separating into 3 columns https://community.qlik.com/t5/QlikView/Counting-Distinct-values-and-separating-into-3-columns/m-p/355247#M493084 <HTML><HEAD></HEAD><BODY><P>Like a charm.&nbsp; Thanks!</P></BODY></HTML> Fri, 15 Jun 2012 14:47:22 GMT https://community.qlik.com/t5/QlikView/Counting-Distinct-values-and-separating-into-3-columns/m-p/355247#M493084 2012-06-15T14:47:22Z