Change text in STRING to be more understandable

[David_K]

Hello everyone (again 😁)

Requesting some help on how to change the contents of a STRING in a column of data. 

I have a column of data that contains 4 main comments, 3 of which are fully understandable to the reader of the report, however I need to revise the text for the 4th comment i.e.: change "DongleBerry" to "Strawberry"

In another visualization tool I would just use an IF statement - IF([Column A] = "DongleBerry" THEN "Strawberry" ELSE [Column A]) END, but I cant find a similar function in QLIK.

Can I please ask for your guidance on how to solve this.

Many Thanks

David 

[Chanty4u · Accepted solution]

try this

 IF([Column A] = 'DongleBerry', 'Strawberry' , [Column A])   as YourCoulmn