topic Re: ALL EXPRESSIONS IN A SAME PLACE in QlikView

ALL EXPRESSIONS IN A SAME PLACE

Wed, 08 Oct 2014 12:59:25 GMT

i have lots of tabs with lots of charts and diagrams that a phrase is repeated in them. now i should replace it with another phrase. so i should replace in any chart and any diagram expression. i want to know if there is somewhere or some way to do the replacement once?

thanks

Re: ALL EXPRESSIONS IN A SAME PLACE

alexandros17 — Wed, 08 Oct 2014 13:01:44 GMT

ley myvar = expression

use myvar instead of the expression

Re: ALL EXPRESSIONS IN A SAME PLACE

JonnyPoole — Wed, 08 Oct 2014 13:05:52 GMT

Under Settings -> Expressions Overview, there is a find/replace function that you can try.

Using variables will also help minimize repetition of code. There are some advanced techniques to externalize all variable definitions (using INCLUDE statements) as well so you can do the find/replace in cool editors like notepad++.

Re: ALL EXPRESSIONS IN A SAME PLACE

DavidFoster1 — Wed, 08 Oct 2014 13:05:56 GMT

There is an 'expression overview' screen available from the settings menu that will allow you to do global replacements/etc.