topic Re: Set analysis distinct in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-distinct/m-p/723186#M475763 <HTML><HEAD></HEAD><BODY><P>Perfect, thank you</P></BODY></HTML> Mon, 07 Jul 2014 12:35:03 GMT 2014-07-07T12:35:03Z Set analysis distinct https://community.qlik.com/t5/QlikView/Set-analysis-distinct/m-p/723183#M475760 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have the expression =Count({$&lt;Type={'Weekly Contact'}&gt;}[MeetingSubID]). How can I tweak this so that it counts on distinct MeetingSubID (This field has duplicates).</P><P></P><P>Thank you</P><P></P><P>H</P></BODY></HTML> Mon, 07 Jul 2014 12:05:39 GMT https://community.qlik.com/t5/QlikView/Set-analysis-distinct/m-p/723183#M475760 2014-07-07T12:05:39Z Re: Set analysis distinct https://community.qlik.com/t5/QlikView/Set-analysis-distinct/m-p/723184#M475761 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=Count({$&lt;Type={'Weekly Contact'}&gt;} DISTINCT [MeetingSubID])</SPAN></P></BODY></HTML> Mon, 07 Jul 2014 12:07:24 GMT https://community.qlik.com/t5/QlikView/Set-analysis-distinct/m-p/723184#M475761 jonathandienst 2014-07-07T12:07:24Z Re: Set analysis distinct https://community.qlik.com/t5/QlikView/Set-analysis-distinct/m-p/723185#M475762 <HTML><HEAD></HEAD><BODY><P>Try like</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=Count( <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">DISTINCT</SPAN>&nbsp; {$&lt;Type={'Weekly Contact'}&gt;}&nbsp; [MeetingSubID])</SPAN></P></BODY></HTML> Mon, 07 Jul 2014 12:32:08 GMT https://community.qlik.com/t5/QlikView/Set-analysis-distinct/m-p/723185#M475762 its_anandrjs 2014-07-07T12:32:08Z Re: Set analysis distinct https://community.qlik.com/t5/QlikView/Set-analysis-distinct/m-p/723186#M475763 <HTML><HEAD></HEAD><BODY><P>Perfect, thank you</P></BODY></HTML> Mon, 07 Jul 2014 12:35:03 GMT https://community.qlik.com/t5/QlikView/Set-analysis-distinct/m-p/723186#M475763 2014-07-07T12:35:03Z