Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Formatting the Text field values

Hi All,

I have Field Value in Text format

"New Orleans"

How can I change it into 'New+Orleans'

in the script itself.

--

3 Replies

Re: Formatting the Text field values

HI

Try like this

=Replace(FieldValue('TextField',1),' ','+')

Hope it helps

srikanthsri1
Valued Contributor

Re: Formatting the Text field values

i will use mapping load, & applymap to change data values

Not applicable

Re: Formatting the Text field values

this one worked

Replace(TextField,' ','+')

Community Browser