https://community.qlik.com/t5/QlikView/How-can-i-write-an-expression-with-if-statement-applymap-and/m-p/1639617#M595011 <P>Hi guys,</P><P>attached is a sample data file (is a personal/desktop) edition.</P><P>The output i want to obtain is the following:</P><P>if field5 = 0,&nbsp; the first 5 number of field4 and the last two of the same field.</P><P>applymap and left() / right () functions can coexist?</P><P>Thanks,</P><P>Mattia</P> Sat, 16 Nov 2024 19:49:00 GMT Mattia 2024-11-16T19:49:00Z https://community.qlik.com/t5/QlikView/How-can-i-write-an-expression-with-if-statement-applymap-and/m-p/1639617#M595011 <P>Hi guys,</P><P>attached is a sample data file (is a personal/desktop) edition.</P><P>The output i want to obtain is the following:</P><P>if field5 = 0,&nbsp; the first 5 number of field4 and the last two of the same field.</P><P>applymap and left() / right () functions can coexist?</P><P>Thanks,</P><P>Mattia</P> Sat, 16 Nov 2024 19:49:00 GMT https://community.qlik.com/t5/QlikView/How-can-i-write-an-expression-with-if-statement-applymap-and/m-p/1639617#M595011 Mattia 2024-11-16T19:49:00Z https://community.qlik.com/t5/QlikView/How-can-i-write-an-expression-with-if-statement-applymap-and/m-p/1639619#M595012 <P>May be this</P><LI-CODE lang="markup">If([FIELD5] = 0, Left(ApplyMap('KEY_TO_FIELD4', [FIELD2], 'n/a'), 7) &amp; ',' &amp; Right(ApplyMap('KEY_TO_FIELD4', [FIELD2], 'n/a'), 2)) as New_Field</LI-CODE> Thu, 24 Oct 2019 16:23:38 GMT https://community.qlik.com/t5/QlikView/How-can-i-write-an-expression-with-if-statement-applymap-and/m-p/1639619#M595012 sunny_talwar 2019-10-24T16:23:38Z