https://community.qlik.com/t5/QlikView/SUM-with-SubField-in-SetExpression/m-p/1591078#M738000 <P>Try this:</P><P>SUM( {$&lt;TextG1 = {'$(=subfield(Concat(distinct TextG1,','),',',1))'} , JAHR={'2017'}&gt;} SALDO)</P><P>- Marcus</P> Wed, 12 Jun 2019 14:00:26 GMT marcus_sommer 2019-06-12T14:00:26Z https://community.qlik.com/t5/QlikView/SUM-with-SubField-in-SetExpression/m-p/1590964#M737999 <P>Hello all,</P><P>Why is this expression wrong?</P><P>=NUM(SUM( {$&lt;TextG1 = {"=subfield(Concat(distinct TextG1,','),',',1)"} , JAHR={'2017'}&gt;} SALDO),'#.###,##'))</P><P>Thanks in advance!</P> Sat, 16 Nov 2024 20:41:03 GMT https://community.qlik.com/t5/QlikView/SUM-with-SubField-in-SetExpression/m-p/1590964#M737999 gf 2024-11-16T20:41:03Z https://community.qlik.com/t5/QlikView/SUM-with-SubField-in-SetExpression/m-p/1591078#M738000 <P>Try this:</P><P>SUM( {$&lt;TextG1 = {'$(=subfield(Concat(distinct TextG1,','),',',1))'} , JAHR={'2017'}&gt;} SALDO)</P><P>- Marcus</P> Wed, 12 Jun 2019 14:00:26 GMT https://community.qlik.com/t5/QlikView/SUM-with-SubField-in-SetExpression/m-p/1591078#M738000 marcus_sommer 2019-06-12T14:00:26Z https://community.qlik.com/t5/QlikView/SUM-with-SubField-in-SetExpression/m-p/1591356#M738001 Thank you very much Marcus!<BR /><BR />Regards,<BR />Gf Thu, 13 Jun 2019 05:58:46 GMT https://community.qlik.com/t5/QlikView/SUM-with-SubField-in-SetExpression/m-p/1591356#M738001 gf 2019-06-13T05:58:46Z