topic Expression based on Distinct value in QlikView https://community.qlik.com/t5/QlikView/Expression-based-on-Distinct-value/m-p/651866#M1081540 <HTML><HEAD></HEAD><BODY><P><BR />Hello everybody,</P><P></P><P>I have a problem to make an expression based on a Distinct value.</P><P>The expression I would like to make looks like this:</P><P></P><P>Field 'Gecontroleerde_Colli':</P><P>Sum ('PC_Colli_Checked' based on the Distinct value 'PC_Ass')</P><P></P><P>Nothing I do works, can anybody help me with this issue please????</P><P>I'll atach a copy of the QVW.</P><P></P><P>Monique</P></BODY></HTML> Wed, 25 Jun 2014 10:40:07 GMT amber2000 2014-06-25T10:40:07Z Expression based on Distinct value https://community.qlik.com/t5/QlikView/Expression-based-on-Distinct-value/m-p/651866#M1081540 <HTML><HEAD></HEAD><BODY><P><BR />Hello everybody,</P><P></P><P>I have a problem to make an expression based on a Distinct value.</P><P>The expression I would like to make looks like this:</P><P></P><P>Field 'Gecontroleerde_Colli':</P><P>Sum ('PC_Colli_Checked' based on the Distinct value 'PC_Ass')</P><P></P><P>Nothing I do works, can anybody help me with this issue please????</P><P>I'll atach a copy of the QVW.</P><P></P><P>Monique</P></BODY></HTML> Wed, 25 Jun 2014 10:40:07 GMT https://community.qlik.com/t5/QlikView/Expression-based-on-Distinct-value/m-p/651866#M1081540 amber2000 2014-06-25T10:40:07Z