topic calculated expression label and [] and re-using complex expressions in QlikView

calculated expression label and [] and re-using complex expressions

RSvebeck — Fri, 09 Dec 2011 12:52:29 GMT

A little problem here regarding re-using expressions when the expression has a calulated label.

As we all know, it is possible to refer to a expression in a chart using [] in another expression.

This is great for complex expressions since we don't have to maintain the code of the expression several times My problem is though, that I have to use a calulated label for a complex expression, and I need to re-use that expression several times.

My label is (quite simplified) like this: "=max(F3)"

How can I avoid being forced to write my expression twice when I need the same expression in another expression in the same chart?

This is in a pivot chart so I guess I can not create a "hidden expression that has a fixed label".

Any help appreciated.

And btw - actually a second question: Is there a way to store expressions "globabaly" so they can be shared between many QVW´s - or shared from one chart to another in the same document? Like the $(Include script.qvs) thing that is very good to use for load scripts.

Regards Robert

calculated expression label and [] and re-using complex expressions

swuehl — Fri, 09 Dec 2011 12:57:34 GMT

Robert,

to your second question, I would recommend using variables for this (sharing expression definitions between qvw's / objects). For example, attached link describes how to reuse variables for point in time reporting using variables:

http://iqlik.wordpress.com/2011/01/01/point-in-time-reporting-out-of-the-box/

Hope this helps,

Stefan

calculated expression label and [] and re-using complex expressions

RSvebeck — Mon, 12 Dec 2011 12:59:46 GMT

Using variables as expressions solves all my problems! Thanks Stefan!