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?
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).
