https://community.qlik.com/t5/QlikView/Change-part-of-script/m-p/1836395#M1214932 <P>Hi</P><P>I have data that I load from an excel file.&nbsp; One of the columns in the data is a unit of measure column.&nbsp; The unit of measure for example can be EA or P10.&nbsp; In this cases I would like to have in my script a "formula" to convert the EA to a "1" and the P10 to the "10" only</P><P>How can I do this?</P><P>Thank you</P> Wed, 15 Sep 2021 15:07:10 GMT DinaH 2021-09-15T15:07:10Z https://community.qlik.com/t5/QlikView/Change-part-of-script/m-p/1836395#M1214932 <P>Hi</P><P>I have data that I load from an excel file.&nbsp; One of the columns in the data is a unit of measure column.&nbsp; The unit of measure for example can be EA or P10.&nbsp; In this cases I would like to have in my script a "formula" to convert the EA to a "1" and the P10 to the "10" only</P><P>How can I do this?</P><P>Thank you</P> Wed, 15 Sep 2021 15:07:10 GMT https://community.qlik.com/t5/QlikView/Change-part-of-script/m-p/1836395#M1214932 DinaH 2021-09-15T15:07:10Z https://community.qlik.com/t5/QlikView/Change-part-of-script/m-p/1836420#M1214933 <P>Your load script formula can be:&nbsp; Pick(Match([unit of measure column], 'EA', 'P10'), 1, 10)</P><P>You can use that to multiply by your measurement column.</P> Wed, 15 Sep 2021 15:55:15 GMT https://community.qlik.com/t5/QlikView/Change-part-of-script/m-p/1836420#M1214933 stevejoyce 2021-09-15T15:55:15Z