Using the Property of Sheet objects as value

[#1]

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?

[Anonymous]

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.

[whiteline]

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.

[#4]

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!

[whiteline]

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.

[#6 · Accepted solution]

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