Find/Replace in QlikView expression - how does it work

[zagzebski]

I have a field in many expressions,  "Net",  that I want to replace with "Amount". I thought it would be as simple as going into Expression Overview and Clicking the Find/Replace button and putting a "Net" in find and "Amount" in Replace, click Replace All, then Close, then Apply and finally OK. But yet I go right to the chart/expressions on that sheet and "Net" is still in a bunch of the expressions. This is so frustrating!

Is there anything special about this? Can I Find/Replace to act much as in Excel?

Thanks,

Steve

[JonnyPoole]

I haven't needed to rely on it myself. The following thread gives some pointers and a potential workaround:

Global Find and Replace

[jagan]

Hi,

I think it is not possible, if you are loading expressions from text file using $(Include) and variables then you can find and replace in a single shot.

Your text should consists of expressions like below

SET vExpression1 = Sum(Measure1);

SET vExpression2 = Count(DISTINCT ID);

And in Qlikview script you have to include this text file like below

=$(Include=filepath\fileName.txt);

Now in chart you simply use

=$(vExpression1)

OR

=$(vExpression2)

Hope this helps you.

Regards,

Jagan.

[jagan]

Or

you can try like this

Expression Overview-> Click Find/Replace -> Give Find and replace values -> Click Find now and Replace until all values are replaced.

Regards,

Jagan.

[ValeriyaBartosh]

Hello, I have the same problem

How did you resolved it?