Lets say i have this expression
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
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.
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.