varible expression in variable expression

[adamdavi3s]

Hi All,

Having a daft moment and can't remember the answer to this

example:

vCost:  sum(cost)

vIncome:  sum(Income)

I have something like pick(match(dimension,'Cost','Income'),$(vCost),$(vIncome))

How do I then stash this in a variable that can be used at row level in a chart:

e.g if I do this, it obviously gives the same answer for every row as the cost and income variables are calculated at the chart level

vPickMatch: pick(match(dimension,'Cost','Income),$(vCost),(vIncome))

stalwar1‌ help me out, its been a while!

[tresesco]

While defining the variables, try removing the '=' from the front.

[adamdavi3s]

Yes sorry the variables do not have an = in the start (variables 101!), my OP is misleading and now corrected

[tresesco]

Could you share your sample qvw?

[sunny_talwar]

And are you using your variable with dollar sign expansion or not? I think you need to use $(vPickMatch) instead of vPickMatch only

[adamdavi3s]

I just spun up a quick demo and it works as I expected... Must be something in my main app DM causing the issue!

I

[adamdavi3s]

Yeah I was, thought I was having a funny 5 but think it must be something else...