topic Multiple expession lines find and replace in QlikView

Multiple expession lines find and replace

Fri, 09 Mar 2012 11:58:33 GMT

Hello,

I have been trying to find a way to replace multiple lines in a group of expressions with a different set of multiple lines via expression overview. This is due to having an expression used in approximately 400 charts that needs changing. The expression is around 50 lines long. It is just one block I need to change although changing the whole expression would not be a problem.

In the edit expression screen if I select a group of lines then take the find/replace option the block of lines is searched for and if you hover over the find box it shows the lines to be searched for. This would infer that there is a way to enter multiple lines in the prompt.

I cannot work out how to replace with a different set of lines.

When copy and paste is used to populate the find with multiple lines it does not seem to work and the “select then take the find/replace option” is not available in expression overview for find side and as above I cannot work out how to replace with multiple lines.

Am I missing something obvious about how to enter multiple lines in the find and replace boxes.

An example of what I need to do would be great or any other work around for a mass update of an expression welcome.

Find

111

222

333

Replace with

444

555

666

Hope this makes sense!

Regards,

Paul.

QlikView - Version 10 SR1.

Multiple expession lines find and replace

jjfabian — Fri, 09 Mar 2012 14:34:08 GMT

If you use an expression that frequently I would replace it entirely - with a variable.

That way you have to manage only ONE variable as opposed to 400 expressions.

Can you replace all your expressions in question with a variable?

Multiple expession lines find and replace

Fri, 09 Mar 2012 16:34:45 GMT

Hello Jakob,

Thanks for the response.

We do use variables for many of our expressions and this works well.

With hindsight this expression should have been done in this way but it unfortunately wasn't.

To change to a variable would also require a search over multiple expression lines which is what I am struggling to work out how to acheive.

Regards, Paul.