topic Re: Reusing Expressions in QlikView

Reusing Expressions

Fri, 27 Nov 2015 17:51:34 GMT

I just started learning QlikView, and I am learning by watching video in youtube. I came across this video, and I have a question. Why do we keep the variable in an Excel file, can't we just do them all in the script area? If we can do it in script area, is there any advantage(s) to do it Excel vs script area?

Thanks in advance.

Phyllis

Reusing Expressions - YouTube

Re: Reusing Expressions

swuehl — Fri, 27 Nov 2015 18:27:39 GMT

For example, if your variable contains dollar sign expansions $() to be expanded on front end, I think it's easier to define these in an external file (e.g. excel) than in a SET / LET statement (where QV tries to expand the dollar sign expansion in the script).

Re: Reusing Expressions

Anonymous — Fri, 27 Nov 2015 18:42:34 GMT

If you keep expressions externally to a specific script [maybe in an Excel file] , then they can be used in multiple qvw's.

An example could be rgb colour expressions for corporate colours.

Re: Reusing Expressions

Siva_Sankar — Mon, 30 Nov 2015 09:00:59 GMT

qlikfix.com/2011/09/21/storing-variables-outside-of-qlikview/