topic Variable with Set Statement in QlikView

Variable with Set Statement

Thu, 24 Feb 2011 17:38:18 GMT

In the load script I define X as follows:

Set X = "$(Y) * 100";

Y is an input variable.

As Y changes X is not updating.
It remains 100 time the value of Y when the document was loaded.

How can I force $(X) to update whenever Y changes?

Variable with Set Statement

Thu, 24 Feb 2011 17:41:41 GMT

Try Let, not Set.

What does your variable look like after it is loaded?

Variable with Set Statement

isaiah82 — Thu, 24 Feb 2011 17:42:33 GMT

Try LET instead of SET. -Isaiah

Variable with Set Statement

Thu, 24 Feb 2011 18:52:55 GMT

I've tried let. It does not seem to work at all.

( Results to null )

Variable with Set Statement

isaiah82 — Thu, 24 Feb 2011 19:04:53 GMT

$(Y) is being evaluated and stored in the variable. Check the variable definition after your load finishes. You can just change the definition there (e.g. '=$(Y)*100' without the quotes) or build this out in your script using chr() functions. Let me know if that doesn't make any sense.