topic Re: Count distinct combinations of two fields in QlikView https://community.qlik.com/t5/QlikView/Count-distinct-combinations-of-two-fields/m-p/763711#M472206 <HTML><HEAD></HEAD><BODY><P>What dimensions do you want in your straight table?</P><P></P><P>You could just try using Count(Distinct %Product &amp; %Depot) which would count the distinct combinations available.</P><P></P><P>Otherwise if you just want the figure, create a straight table with %Product and %Depot as your dimensions and just shove a count in there!</P></BODY></HTML> Mon, 26 Jan 2015 11:56:37 GMT morganaaron 2015-01-26T11:56:37Z Count distinct combinations of two fields https://community.qlik.com/t5/QlikView/Count-distinct-combinations-of-two-fields/m-p/763708#M472203 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I would like to calculate a simple Count of distinct combinations of two fields.</P><P></P><P>The two fields are %Product and %Depot. To count the unique combinations of %Product and %Depot, do I need something like the following?</P><P></P><P><EM style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">=Aggr(Count(Distinct %Product),%Depot)</EM></P><P><EM style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></EM></P><P>Not sure if I'm on the right track...the equation will just be used in a straight table.</P><P></P><P>Thanks!</P><P></P><P>Mel</P></BODY></HTML> Mon, 26 Jan 2015 11:46:00 GMT https://community.qlik.com/t5/QlikView/Count-distinct-combinations-of-two-fields/m-p/763708#M472203 2015-01-26T11:46:00Z Re: Count distinct combinations of two fields https://community.qlik.com/t5/QlikView/Count-distinct-combinations-of-two-fields/m-p/763709#M472204 <HTML><HEAD></HEAD><BODY><P>Maybe like this:</P><P> =Count(Distinct( %Product))+Count(Distinct(%Depot))</P></BODY></HTML> Mon, 26 Jan 2015 11:50:03 GMT https://community.qlik.com/t5/QlikView/Count-distinct-combinations-of-two-fields/m-p/763709#M472204 robert_mika 2015-01-26T11:50:03Z Re: Count distinct combinations of two fields https://community.qlik.com/t5/QlikView/Count-distinct-combinations-of-two-fields/m-p/763710#M472205 <HTML><HEAD></HEAD><BODY><P>count(distinct <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.7272720336914px;">%Product &amp; '|' &amp; %Depot)</SPAN></P></BODY></HTML> Mon, 26 Jan 2015 11:54:48 GMT https://community.qlik.com/t5/QlikView/Count-distinct-combinations-of-two-fields/m-p/763710#M472205 maxgro 2015-01-26T11:54:48Z Re: Count distinct combinations of two fields https://community.qlik.com/t5/QlikView/Count-distinct-combinations-of-two-fields/m-p/763711#M472206 <HTML><HEAD></HEAD><BODY><P>What dimensions do you want in your straight table?</P><P></P><P>You could just try using Count(Distinct %Product &amp; %Depot) which would count the distinct combinations available.</P><P></P><P>Otherwise if you just want the figure, create a straight table with %Product and %Depot as your dimensions and just shove a count in there!</P></BODY></HTML> Mon, 26 Jan 2015 11:56:37 GMT https://community.qlik.com/t5/QlikView/Count-distinct-combinations-of-two-fields/m-p/763711#M472206 morganaaron 2015-01-26T11:56:37Z