topic Re: Replace function in QlikView

Replace function

Anonymous — Tue, 08 Sep 2015 16:46:43 GMT

Hi,

I'd like to rename several values in a field through setting an expression on the forefront.

Say, value 'A' to value 'A1', 'B' to value 'B1', 'C' to value 'C1'.

What syntax should be used then?

Thank you in advance,

Larisa

Re: Replace function

marcus_sommer — Tue, 08 Sep 2015 16:50:59 GMT

Maybe something like this:

If(match(Field, 'A', 'B', 'C'), Field & '1', Field)

If there are more values which needed to be renamed more complex a mapping-table would be useful.

- Marcus

Re: Replace function

malini_qlikview — Tue, 08 Sep 2015 16:52:19 GMT

You can use Replace() function

Re: Replace function

Anonymous — Tue, 08 Sep 2015 16:56:03 GMT

Do you mean embedded Replace?

Replace(Replace(Field, Value, Value2), Value3, Value4))

Re: Replace function

Anonymous — Tue, 08 Sep 2015 17:09:06 GMT

I see,

Is embedded Replace a good option?

Replace(Replace(Field, ValueOld1, ValueNew1), ValueOld2, ValueNew2))

Re: Replace function

malini_qlikview — Tue, 08 Sep 2015 17:09:25 GMT

=Replace(Field,Field,Field&'1')

Re: Replace function

Anonymous — Tue, 08 Sep 2015 18:10:50 GMT

Yes, but if A should be renamed to Apple, B to Bright, C to Clever, this approach won't work. I see that I could use a mapping table, but I am searching for a simpler solution.

Re: Replace function

maxgro — Tue, 08 Sep 2015 18:40:20 GMT

pick(wildmatch(Field,'A','B','C', '*'),'A1','B1','C1',Field)

Re: Replace function

MarcoWedel — Tue, 08 Sep 2015 23:25:50 GMT

Hi,

another solution could be:

hope this helps

regards

Marco

Re: Replace function

sunilkumarqv — Wed, 09 Sep 2015 06:55:02 GMT

I'd like to rename several values in a field

=Replace(Fieldname,Fieldname,Fieldname&'1')

Re: Replace function

Anonymous — Wed, 09 Sep 2015 11:31:36 GMT

Thank you! The example is useful.