topic distinct count that keeps all selections besides the WHERE condition in QlikView https://community.qlik.com/t5/QlikView/distinct-count-that-keeps-all-selections-besides-the-WHERE/m-p/976947#M643650 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>I'm new to Qlik but familiar with SQL so please forgive any incorrect terms.</P><P></P><P>I'm trying to write an expression return the distinct count of the values in [Visit.Event.ID] where the field [Department] = ''Repair' and every other user selection applies also.&nbsp; (i.e. Dealership, Grade, etc)</P><P></P><P>This seems to be close, but not quite.&nbsp; </P><P></P><P>Count({$&lt;Department={'Repair'}&gt;}Visit.Event.ID)</P><P></P><P>Can anyone tell me what I'm missing?</P><P></P><P>Thanks in advance!</P></BODY></HTML> Tue, 22 Dec 2015 23:01:18 GMT 2015-12-22T23:01:18Z distinct count that keeps all selections besides the WHERE condition https://community.qlik.com/t5/QlikView/distinct-count-that-keeps-all-selections-besides-the-WHERE/m-p/976947#M643650 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>I'm new to Qlik but familiar with SQL so please forgive any incorrect terms.</P><P></P><P>I'm trying to write an expression return the distinct count of the values in [Visit.Event.ID] where the field [Department] = ''Repair' and every other user selection applies also.&nbsp; (i.e. Dealership, Grade, etc)</P><P></P><P>This seems to be close, but not quite.&nbsp; </P><P></P><P>Count({$&lt;Department={'Repair'}&gt;}Visit.Event.ID)</P><P></P><P>Can anyone tell me what I'm missing?</P><P></P><P>Thanks in advance!</P></BODY></HTML> Tue, 22 Dec 2015 23:01:18 GMT https://community.qlik.com/t5/QlikView/distinct-count-that-keeps-all-selections-besides-the-WHERE/m-p/976947#M643650 2015-12-22T23:01:18Z Re: distinct count that keeps all selections besides the WHERE condition https://community.qlik.com/t5/QlikView/distinct-count-that-keeps-all-selections-besides-the-WHERE/m-p/976948#M643651 <HTML><HEAD></HEAD><BODY><P>Maybe just a DISTINCT qualifier?</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Count({$&lt;Department={'Repair'}&gt;} DISTINCT [Visit.Event.ID] )</SPAN></P></BODY></HTML> Wed, 23 Dec 2015 00:10:52 GMT https://community.qlik.com/t5/QlikView/distinct-count-that-keeps-all-selections-besides-the-WHERE/m-p/976948#M643651 swuehl 2015-12-23T00:10:52Z