Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
AndyHill
Contributor
Contributor

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

Labels (2)
1 Solution

Accepted Solutions
sultanam
Contributor III
Contributor III

Hi Andy,

you can use Replace function like below

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

 

Regards,
Sultan

View solution in original post

1 Reply
sultanam
Contributor III
Contributor III

Hi Andy,

you can use Replace function like below

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

 

Regards,
Sultan