topic Re: Defining a local variable in a chart expression in QlikView

Defining a local variable in a chart expression

Fri, 21 Oct 2011 18:47:53 GMT

Is it possible to define a local variable within a chart expression? I need to manipulate a calculated value multiple times in the same expression and it would make my expression much cleaner and easier to manage if I could just refer to a variable instead of copying the calculation every time I need the value.

Re: Defining a local variable in a chart expression

Fri, 21 Oct 2011 19:24:52 GMT

Hello,

When you create the variable don't have an =. Just the expression. Then to reference it in the expression you would do something like: $(vVariableName)

Regards,
Jeff

Defining a local variable in a chart expression

Tue, 01 Nov 2011 14:31:03 GMT

Hey Jeff, sorry I haven't gotten back to this in a while. I've never worked with variables before, so I'm not even sure where to begin with that. Do you create variables in the load script? And can you give me an example of what a simple variable definition looks like and how it differs from what you suggested above?

Re: Defining a local variable in a chart expression

Tue, 01 Nov 2011 14:55:23 GMT

Are you planning to use the variable in the load script? Or would you be using it in your charts/tables?

If you are using in the load script an example would be

LET vVariable = 'sum expression

referenced with $(vVariable)

If not in the load script:

Settings --> Variable Overview --> Add

Name your variable then click on it, and down in the definition box, write your expression.

Regards,
Jeff

Re: Defining a local variable in a chart expression

Tue, 01 Nov 2011 15:05:00 GMT

Ok, I think that makes sense. I guess my question was whether it was possible to define a variable within a chart expression (useful and less cluttered than other options if you use the same piece of code multiple times in a single expression but nowhere else in qview file). I suppose defining it in Variable Overview is an ok substitute. Thanks for your help!