topic One-to-many duplication in QlikView https://community.qlik.com/t5/QlikView/One-to-many-duplication/m-p/175182#M43727 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>You can try this</P><P></P><P style="font-weight: bold"></P><P style="font-weight: bold">If(Name='Jack',sum(Salary * K),sum(Salary))</P><P></P><P>Anders</P><BR /><BR /> <BR /><BR /></BODY></HTML> Wed, 19 Jan 2011 11:58:26 GMT 2011-01-19T11:58:26Z One-to-many duplication https://community.qlik.com/t5/QlikView/One-to-many-duplication/m-p/175180#M43725 <HTML><HEAD></HEAD><BODY><P>Hi everybody!</P><P>I have expression sum(if(name = 'Jack', Salary*K, Salary)).<BR />If name isnt Jack but for ex. John (as below), result is not 5000 as I need, but<BR />10000 (5000 duplicates). Can it be solved somehow?</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-3306_sourceID:3306" /></P><P>thanx</P></BODY></HTML> Wed, 19 Jan 2011 10:44:43 GMT https://community.qlik.com/t5/QlikView/One-to-many-duplication/m-p/175180#M43725 2011-01-19T10:44:43Z SV:One-to-many duplication https://community.qlik.com/t5/QlikView/One-to-many-duplication/m-p/175181#M43726 <HTML><HEAD></HEAD><BODY><P>You need to get a count(K) in there. something like:</P><P>sum(if(name = 'Jack', Salary*K/<STRONG>count(K)</STRONG> ,Salary))</P><P>/Michael</P></BODY></HTML> Wed, 19 Jan 2011 11:06:43 GMT https://community.qlik.com/t5/QlikView/One-to-many-duplication/m-p/175181#M43726 2011-01-19T11:06:43Z One-to-many duplication https://community.qlik.com/t5/QlikView/One-to-many-duplication/m-p/175182#M43727 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>You can try this</P><P></P><P style="font-weight: bold"></P><P style="font-weight: bold">If(Name='Jack',sum(Salary * K),sum(Salary))</P><P></P><P>Anders</P><BR /><BR /> <BR /><BR /></BODY></HTML> Wed, 19 Jan 2011 11:58:26 GMT https://community.qlik.com/t5/QlikView/One-to-many-duplication/m-p/175182#M43727 2011-01-19T11:58:26Z