topic Re: Formating text to number formats in QlikView

Formating text to number formats

Wed, 09 Jul 2014 08:50:49 GMT

Hi,

I'm sure this is simple but I cannot manage to get the following data to be formatted correctly nor whether to do this in the script or in the UI itself.

Source data values

0000033320

0000000199

0000123123

Target data value

£333.20

£1.99

£1,231.23

Any ideas?

Many thanks,

Natalie

Re: Formating text to number formats

MK_QSL — Wed, 09 Jul 2014 08:56:06 GMT

LOAD

Money(LEFT(FieldName,LEN(FieldName)-2) &'.'& RIGHT(FieldName,2),'£#,##0.00') as FieldNameMoneyFormat Inline

[

FieldName

0000033320

0000000199

0000123123

];

Re: Formating text to number formats

Wed, 09 Jul 2014 11:10:08 GMT

Thank you so much for your prompt response. This works perfectly!!!