https://community.qlik.com/t5/App-Development/All-value-of-dimension-for-one-expression-in-concat/m-p/1593619#M43654 <P>Hello,</P><P>&nbsp;</P><P>i want to display all the value for all dimension in a concat :&nbsp;</P><P>- concat for dimension&nbsp; :&nbsp;concat(distinct code_sous_traitant,'/',code_sous_traitant) =&gt; result AAA/BBBB</P><P>- concat for expression :&nbsp;concat(distinct aggr($(v_Encours_AttendusSAV_EEversSTT_DernierJour),code_sous_traitant),'/',code_sous_traitant) =&gt; 12 (if BBBB or AAA had no value)</P><P>How to show 12/0 in the result of expression ?</P><P>Thanks for your help,</P><P>Sophie</P> Wed, 19 Jun 2019 13:04:58 GMT sophie_bd 2019-06-19T13:04:58Z https://community.qlik.com/t5/App-Development/All-value-of-dimension-for-one-expression-in-concat/m-p/1593619#M43654 <P>Hello,</P><P>&nbsp;</P><P>i want to display all the value for all dimension in a concat :&nbsp;</P><P>- concat for dimension&nbsp; :&nbsp;concat(distinct code_sous_traitant,'/',code_sous_traitant) =&gt; result AAA/BBBB</P><P>- concat for expression :&nbsp;concat(distinct aggr($(v_Encours_AttendusSAV_EEversSTT_DernierJour),code_sous_traitant),'/',code_sous_traitant) =&gt; 12 (if BBBB or AAA had no value)</P><P>How to show 12/0 in the result of expression ?</P><P>Thanks for your help,</P><P>Sophie</P> Wed, 19 Jun 2019 13:04:58 GMT https://community.qlik.com/t5/App-Development/All-value-of-dimension-for-one-expression-in-concat/m-p/1593619#M43654 sophie_bd 2019-06-19T13:04:58Z