topic Using # character in set analysis in QlikView https://community.qlik.com/t5/QlikView/Using-character-in-set-analysis/m-p/430055#M1158472 <HTML><HEAD></HEAD><BODY><P>My field data Part_Number has items prefaced with #.&nbsp; I cannot get that to work in a set analysis, any idea? Count ({} DISTINCT Account_Id_Key) - This works Count ({} DISTINCT Account_Id_Key)&nbsp; - This does not work nor does Count ({} DISTINCT Account_Id_Key) nor does Count ({} DISTINCT Account_Id_Key)</P></BODY></HTML> Wed, 12 Dec 2012 13:42:51 GMT Anonymous 2012-12-12T13:42:51Z Using # character in set analysis https://community.qlik.com/t5/QlikView/Using-character-in-set-analysis/m-p/430055#M1158472 <HTML><HEAD></HEAD><BODY><P>My field data Part_Number has items prefaced with #.&nbsp; I cannot get that to work in a set analysis, any idea? Count ({} DISTINCT Account_Id_Key) - This works Count ({} DISTINCT Account_Id_Key)&nbsp; - This does not work nor does Count ({} DISTINCT Account_Id_Key) nor does Count ({} DISTINCT Account_Id_Key)</P></BODY></HTML> Wed, 12 Dec 2012 13:42:51 GMT https://community.qlik.com/t5/QlikView/Using-character-in-set-analysis/m-p/430055#M1158472 Anonymous 2012-12-12T13:42:51Z