modify value

[PARK_JY]

hi,

I have  one question while using QLIK SENSE.

I want change value.

example: (100)                   =>             (100)loading

                     loading

I don't know how to modify the value.

Please let me know how to modify it.

Thank you:)

[Chanty4u]

am not sure what you are trying but as per my understanding try below

if(value=100,'(100)loading',value) as  Yourfield      in script 

[PARK_JY]

Oh I'm sorry for by lack of explanation.

now value is '(100)

                            loading'.

* (100) -> enter -> loading

[Vegar]

you need to identify your linebreaks and replace them with the string '-> enter ->'. Is this a correct interpretation of your issue?

You can try to use replace (). 

Replace ( [YourField], '

', '-> enter ->') as [NewField]