Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
zagzebski
Creator
Creator

Find/Replace in QlikView expression - how does it work

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

4 Replies
JonnyPoole
Employee
Employee

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

Global Find and Replace

jagan
Luminary Alumni
Luminary Alumni

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
Luminary Alumni
Luminary Alumni

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
Partner - Contributor III
Partner - Contributor III

Hello, I have the same problem

How did you resolved it?