
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Changing more than one value on input
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
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Andy,
you can use Replace function like below
Replace(Replace(Replace(MYFIELD,'ABC',99),'CBA',99),'ZZZ',000) as MYFIELD;
Regards,
Sultan

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Andy,
you can use Replace function like below
Replace(Replace(Replace(MYFIELD,'ABC',99),'CBA',99),'ZZZ',000) as MYFIELD;
Regards,
Sultan
