Changing more than one value on input

AndyHill — Sat, 16 Nov 2024 20:55:07 GMT

Hi There

I am quite new to Qlikview, and I have spent a couple of hours on here trying to work out how to change a couple of values inbound from a SharePoint input. Ideally I would fix the input however it is owned by a different department, so the best solution is to do it on the load part.

Process is:

LOAD

...

,Replace(MYFIELD,'ABC','99') as MYFIELD

...

However I need to make a few more changes ... initially I tried this:

,Replace(MYFIELD,'ABC','99') as MYFIELD

,Replace(MYFIELD,'CBA','99') as MYFIELD

,Replace(MYFIELD,'ZZZ','00') as MYFIELD

However this doesn't work. How is it possible to put multiple "REPLACE" lines together?

Andy

Re: Changing more than one value on input

sultanam — Wed, 08 May 2019 10:27:35 GMT

Hi Andy,

you can use Replace function like below

Replace(Replace(Replace(MYFIELD,'ABC',99),'CBA',99),'ZZZ',000) as MYFIELD;

Regards,
Sultan

topic Re: Changing more than one value on input in QlikView

Changing more than one value on input

Re: Changing more than one value on input