topic Using the Property of Sheet objects as value in QlikView

Using the Property of Sheet objects as value

Tue, 27 May 2014 19:05:16 GMT

Is it possible to reference the value stored on a text object?

Let's say the text object is displaying 123,456.00 from a complex expression. Can I reference the text property and use it as a value for another expression? (i.e. if the name of text object is TX01, can I do something like TX01.TEXT or something similar to get the value?

In a similar fashion, is it possible to reference results of Chart Expressions? Let's say I define an expression calculating Assets and another expression for calculating Liabilities. If I want to get the Net (Asset - Liabilities), can I refer to the result of those expressions instead setting the expressions into variables and re-evaluating them again using dollar expansion?

Re: Using the Property of Sheet objects as value

Anonymous — Tue, 27 May 2014 20:03:39 GMT

You can do it using a macro, but macro is not a good idea. A better way is to use this expression in a variable, and refer to this variable where needed, including this text box.

Re: Using the Property of Sheet objects as value

whiteline — Tue, 27 May 2014 20:07:34 GMT

Hi.

No, you can't reference text object or another chart results within the expression.

If expressions are exactly the same QV evaluate only once. 'Exactly' means that both are equal strings.

Re: Using the Property of Sheet objects as value

Wed, 28 May 2014 13:58:58 GMT

Thanks whiteline for clarifying that. That's what I was trying to avoid if the variable/expression is being evaluated multiple times. Do you have any links/resources about this?

Thanks!

Re: Using the Property of Sheet objects as value

whiteline — Wed, 28 May 2014 16:49:20 GMT

You can test it easily by yourself by creating two charts with the same expressions that take some time to be calculated.

Or believe in QlikView cache:

http://community.qlik.com/blogs/qlikviewdesignblog/2014/04/14/the-qlikview-cache

From some recent version it should also avoid unnecessary calculations for different users.

Re: Using the Property of Sheet objects as value

Wed, 28 May 2014 17:34:46 GMT

Thanks for the link. From there I saw other articles/blogs about Column and Label references which is exactly what I was looking for. And interestingly, there are some performance implications especially with more resource intensive expressions:

Performance (and other) benefits of using expression column and label references « BI Commons

Qlik Tips: Performance using Labels or Column() in charts

http://http//www.qlikfix.com/2011/06/21/testing-the-performance-implications-of-variables-and-label-referencing-versus-d…