topic Variable Expressions within variable expressions in QlikView

Variable Expressions within variable expressions

Anonymous — Fri, 28 Jan 2011 16:25:30 GMT

Hi, i am using multiple variable expressions to create a report. This involves variable expressions referencing other variable expressions.

Are there any limits to the amount of times this can be done?

The reason i ask is that i have tried to replace a field with a variable expression and this has meant my final expression is now returning zero - if i revert back to the field the expression works.

Variable Expressions within variable expressions

Fri, 28 Jan 2011 16:56:41 GMT

There may be a limit at some point, but a variable inside a variable should work. I have a variable that is like:

=If(FIELD='VALUE', var1, var2)

And that works just fine. Are you sure your variable is returning the correct values. You may be able to see what it returns using a Text Object or a chart expression without a label.

Variable Expressions within variable expressions

Anonymous — Fri, 28 Jan 2011 17:10:09 GMT

i have several variables within variables that are working fine.

I have one final variable that adds two previous ones together - this starts to return zero if i add more variable expressions into some of the previous variables i have.

All the other variablesi have are still returning the correct values

Variable Expressions within variable expressions

Mon, 31 Jan 2011 20:20:54 GMT

Hi,

Depending on the expressions in your variables, you may have a quoting issue. In other words, a mixture of double or single quotes that are conflicting with each other. Worth a look.

I hope this helps. Let me know if you need any clarification.

Thanks

Nick

Variable Expressions within variable expressions

Anonymous — Fri, 04 Feb 2011 13:00:40 GMT

Hi, I have some if statements that use single quotes - however the expressions i am modifying do not use any quotations.