topic Re: Find/Replace in QlikView expression - how does it work in QlikView

Find/Replace in QlikView expression - how does it work

zagzebski — Tue, 30 Sep 2014 01:01:46 GMT

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

Re: Find/Replace in QlikView expression - how does it work

JonnyPoole — Tue, 30 Sep 2014 01:36:30 GMT

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

Global Find and Replace

Re: Find/Replace in QlikView expression - how does it work

jagan — Tue, 30 Sep 2014 02:04:44 GMT

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)

=$(vExpression2)

Hope this helps you.

Regards,

Jagan.

Re: Find/Replace in QlikView expression - how does it work

jagan — Tue, 30 Sep 2014 02:08:19 GMT

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.

Re: Find/Replace in QlikView expression - how does it work

ValeriyaBartosh — Wed, 28 Aug 2019 13:44:39 GMT

Hello, I have the same problem

How did you resolved it?