topic Re: Is there a Find and Replace function for text? in QlikView

Is there a Find and Replace function for text?

Wed, 25 Nov 2020 16:16:04 GMT

I'm trying to replace text in dimension/expression labels and/or text objects. Is there such a thing as Find and Replace (similar to Microsoft Word) in QlikView? That would make updating labels much easier.

Re: Is there a Find and Replace function for text?

m_woolf — Wed, 25 May 2016 18:20:05 GMT

Settings|Expression Overview?

Re: Is there a Find and Replace function for text?

sunny_talwar — Wed, 25 May 2016 18:21:52 GMT

or you can try the short cut -> Ctrl + Alt + E will take you to Expression Overview where you can do Find/Replace

Re: Is there a Find and Replace function for text?

MindaugasBacius — Wed, 25 May 2016 18:30:32 GMT

Use Replace function.

Example:

Replace('abcd' , 'a', 'AAA') will return you AAAbcd.

Re: Is there a Find and Replace function for text?

engishfaque — Thu, 26 May 2016 03:29:53 GMT

Dear Katrina,

Yes we have the same option in QlikView such as available in Microsoft Word.

In QlikView we have Expression Overview (Open your Dashboard / App > Settings tab > Expression Overview > Find/Replace > Apply > OK.) where from you can Find/Replace listed below things:

1. Chart Expressions

2. Chart Attributes

3. Color Expressions

4. Show Conditions

5. Other Expressions

Kind regards,

Ishfaque Ahmed

Re: Is there a Find and Replace function for text?

Anonymous — Tue, 21 Feb 2017 01:41:19 GMT

I recently faced this problem and solved it by doing global find replace in a text editor on the contents of the prj folder. Make sure to save a backup first. My process was this, for a file named MyFile.qvw

1. In the same directory as MyFile.qvw, create a folder called MyFile-prj, then save the qvw. You should see a bunch of xml populated in the prj folder.

2. Close the qvw!!

3. Using an editor like Sublime or Notepad++, open all the files in the folder (In Sublime, you can go to File->Open Folder, and open the -prj folder).

4. Find and Replace the field name in ALL the documents in the prj folder. Note -- this will replace the field names in all Expressions, Dimensions, AND the LoadScript, so be careful.

5. Save All the file changes.

6. Reopen the document from within QlikView Desktop using File -> Open. This will rebuild the file contents from the prj folder.