topic Re: Using expressions in variables? in QlikView

Using expressions in variables?

Mon, 14 Oct 2013 14:18:09 GMT

Hello

Lets say i have this expression

Sum(aggr(sum(amount),Date,Organization))

Can i then make a variable called vExpression1 = Sum(aggr(sum(amount),Date,Organization))

And then in my expression field for my chart or straight table just write vExpression1 ?

Ive tried but i cannot seem to get it to work

Re: Using expressions in variables?

v_iyyappan — Mon, 14 Oct 2013 14:21:31 GMT

Hi,

Try like that

var1 = Sum(aggr(sum(amount),Date,Organization))

expression like

= $(var1)

if u not get means please provide sample application.

regards,

Re: Using expressions in variables?

Mon, 14 Oct 2013 14:28:50 GMT

Sorry, cannot provide example..

Re: Using expressions in variables?

tresB — Mon, 14 Oct 2013 14:29:28 GMT

While defining the variable in variable overview window, if you put an '=' symbol and then the expression, then you can simply call the expression by simply putting =variable_name, otherwise put a '$' symbol like: =$(variable_name). This should work fine, if not, it would be something else(your dimension/expression ) rather than the variable expansion issue.

Re: Using expressions in variables?

Mon, 14 Oct 2013 14:35:10 GMT

Could you provide an qvw example?

Cause if i do like that, It does not work on aggr. Its like it does not aggr over my dates, but it takes in action which selections i have made.

Re: Using expressions in variables?

Mon, 14 Oct 2013 14:44:13 GMT

Solved it my self - A rookie mistake

Inserting the variable in qlikview without = does the trick and then referer to the variable by using $(variablename)