topic Re: Distinct Count based on Input Field in QlikView https://community.qlik.com/t5/QlikView/Distinct-Count-based-on-Input-Field/m-p/612955#M226184 <HTML><HEAD></HEAD><BODY><P>Unfortunately, do to specific network limitations, I cannot export the application, though I can manually type specific segments of the script to assist.</P></BODY></HTML> Fri, 02 May 2014 15:07:53 GMT 2014-05-02T15:07:53Z Distinct Count based on Input Field https://community.qlik.com/t5/QlikView/Distinct-Count-based-on-Input-Field/m-p/612953#M226182 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I have an issue that I can't seem to wrap my brain around.&nbsp; I have a Table box with an input field "RankField" against another column "CriteriaField."&nbsp; I need to find a way to get a distinct overall count of the items entered into the "Rank" input field, however when I do a Count(Distinct(RankField)) it gives me a count of the number of distinct entries in the "CriteriaField." </P><P></P><P>CriteriaField&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RankField</P><P></P><P>Fast&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp; </P><P>Cheap&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>Light&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1 </P><P>Durable&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp; </P><P>Small&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</P><P></P><P>My count(distinct(RankField) total shows up as 5, not 4 as I would expect.&nbsp; I have tried playing with the aggr() function but I cannot seem to get what I need.&nbsp; Help please!!!</P><P></P><P>-Easton&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Wed, 23 Apr 2014 18:47:59 GMT https://community.qlik.com/t5/QlikView/Distinct-Count-based-on-Input-Field/m-p/612953#M226182 2014-04-23T18:47:59Z Re: Distinct Count based on Input Field https://community.qlik.com/t5/QlikView/Distinct-Count-based-on-Input-Field/m-p/612954#M226183 <HTML><HEAD></HEAD><BODY><P>may you share application with sample data?</P><P></P><P>regards</P><P>DArek</P></BODY></HTML> Thu, 24 Apr 2014 17:52:54 GMT https://community.qlik.com/t5/QlikView/Distinct-Count-based-on-Input-Field/m-p/612954#M226183 2014-04-24T17:52:54Z Re: Distinct Count based on Input Field https://community.qlik.com/t5/QlikView/Distinct-Count-based-on-Input-Field/m-p/612955#M226184 <HTML><HEAD></HEAD><BODY><P>Unfortunately, do to specific network limitations, I cannot export the application, though I can manually type specific segments of the script to assist.</P></BODY></HTML> Fri, 02 May 2014 15:07:53 GMT https://community.qlik.com/t5/QlikView/Distinct-Count-based-on-Input-Field/m-p/612955#M226184 2014-05-02T15:07:53Z