topic Re: Replace values in field in QlikView

Replace values in field

CanOls — Sat, 16 Nov 2024 19:37:23 GMT

Hi Qlik Community

I would like to compare data across two different tables. Both tables have a field that contain comparable data. They have a field in common that I use as a key to connect the two tables.

The problem is that the naming convention in the two tables is not quite the same. The field contains five possible values but two of the values are named differently. Is it possible to change the name of the values in the one table so that they match up in my Qlik App?

Any help is appreciated

Casper

Re: Replace values in field

QlikJunkie — Thu, 21 Nov 2019 16:26:58 GMT

MapSubstring....!

see if it helps

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/MappingFunctions/MapSubstring.htm

Re: Replace values in field

CanOls — Mon, 25 Nov 2019 11:37:42 GMT

A co worker helped me out This solution did the trick.

if ('FieldName'='FieldValue', 'NewValue, if( 'FieldName'='OtherFieldValue','OtherNewValue', FieldName)) as FieldName

This worked in the script.