topic Adding distinct to this formula in QlikView https://community.qlik.com/t5/QlikView/Adding-distinct-to-this-formula/m-p/297250#M110262 <HTML><HEAD></HEAD><BODY><P>Hi all, </P><P></P><P>I have a straight table which is duplicating on the %KEY_CARS field.</P><P></P><P>How can I have this formula work on only distinct %KEY_CARS values?</P><P></P><P></P><P>=IF(Master.formType like '*79*','Yes',NULL())</P><P></P><P>thanks. </P></BODY></HTML> Thu, 21 Jul 2011 13:38:56 GMT 2011-07-21T13:38:56Z Adding distinct to this formula https://community.qlik.com/t5/QlikView/Adding-distinct-to-this-formula/m-p/297250#M110262 <HTML><HEAD></HEAD><BODY><P>Hi all, </P><P></P><P>I have a straight table which is duplicating on the %KEY_CARS field.</P><P></P><P>How can I have this formula work on only distinct %KEY_CARS values?</P><P></P><P></P><P>=IF(Master.formType like '*79*','Yes',NULL())</P><P></P><P>thanks. </P></BODY></HTML> Thu, 21 Jul 2011 13:38:56 GMT https://community.qlik.com/t5/QlikView/Adding-distinct-to-this-formula/m-p/297250#M110262 2011-07-21T13:38:56Z Adding distinct to this formula https://community.qlik.com/t5/QlikView/Adding-distinct-to-this-formula/m-p/297251#M110263 <HTML><HEAD></HEAD><BODY><P>hei </P><P>try to use</P><P>aggr(IF(Master.formType like '*79*','Yes',NULL()), %KEY_CARS)</P></BODY></HTML> Thu, 21 Jul 2011 13:40:33 GMT https://community.qlik.com/t5/QlikView/Adding-distinct-to-this-formula/m-p/297251#M110263 lironbaram 2011-07-21T13:40:33Z