Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I haven't needed to rely on it myself. The following thread gives some pointers and a potential workaround:
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.
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.
Hello, I have the same problem
How did you resolved it?