https://community.qlik.com/t5/App-Development/Addition-of-two-values-within-the-same-field/m-p/1830169#M68412 <P>i'm thinking replace spaces with '+' and use evaluate:</P><P>in load script:</P><P>evaluate(replace([your field], ' ', '+')) as [your New field]</P> Fri, 20 Aug 2021 10:50:00 GMT stevejoyce 2021-08-20T10:50:00Z https://community.qlik.com/t5/App-Development/Addition-of-two-values-within-the-same-field/m-p/1830154#M68411 <P>Hey,</P><P>I have a field that contains an integer value for the majority of the column. However some of the values have a space in the middle, so two values and only ever two values at most. Instead of removing the space I would like to add the two numbers separated by a space within the same field together.</P><P>I know it would look something like..</P><P>If(Row contains ' '), Take left value, take right value, add together, else no space, carry over whole number to new column</P><P>Is this even possible in Qlik ?</P><P>Thanks!</P> Fri, 20 Aug 2021 10:35:24 GMT https://community.qlik.com/t5/App-Development/Addition-of-two-values-within-the-same-field/m-p/1830154#M68411 LovelyPints 2021-08-20T10:35:24Z https://community.qlik.com/t5/App-Development/Addition-of-two-values-within-the-same-field/m-p/1830169#M68412 <P>i'm thinking replace spaces with '+' and use evaluate:</P><P>in load script:</P><P>evaluate(replace([your field], ' ', '+')) as [your New field]</P> Fri, 20 Aug 2021 10:50:00 GMT https://community.qlik.com/t5/App-Development/Addition-of-two-values-within-the-same-field/m-p/1830169#M68412 stevejoyce 2021-08-20T10:50:00Z