topic naming the expressions in QlikView

naming the expressions

Tue, 05 May 2009 03:33:05 GMT

I have some same expressions (i.e. facts) on different charts on differents sheets with different set of dimensions and they are pretty big. Is there any way to name them and use these names instead to keep the code simple.

I can't use variables as they store a single value.

Any suggetions are appreciated.

Thanks.

naming the expressions

Anonymous — Tue, 05 May 2009 03:41:36 GMT

In fact, variable can be anything, including expression as well.

naming the expressions

Tue, 05 May 2009 03:48:07 GMT

No the problem is , I have the aggregations in my expressions and if you store it in variables it gives you a same single value disregarding the dimensions if used on charts.

naming the expressions

johnw — Tue, 05 May 2009 04:14:23 GMT

Either I'm not understanding the problem, or you're not understanding Michael's solution. Do something like this:

SET vAverage = avg(Value);

Then use this as your expression:

$(vAverage)

QlikView will substitute "avg(Value)", and thus calculate what you're looking for. It should take into account your chart dimensions just like anything else. Example attached.

naming the expressions

rwunderlich — Tue, 05 May 2009 07:40:02 GMT


Raj wrote:I can't use variables as they store a single value.

Raj,

The key to creating reusable expressions in variables is that the variable definition must not include the "=" sign.

-Rob