topic varible expression in variable expression in QlikView

varible expression in variable expression

adamdavi3s — Wed, 07 Feb 2018 11:29:00 GMT

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!

tresB — Wed, 07 Feb 2018 11:32:57 GMT

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

adamdavi3s — Wed, 07 Feb 2018 11:36:05 GMT

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

tresB — Wed, 07 Feb 2018 11:43:18 GMT

Could you share your sample qvw?

sunny_talwar — Wed, 07 Feb 2018 12:02:36 GMT

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

adamdavi3s — Wed, 07 Feb 2018 12:07:52 GMT

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

adamdavi3s — Wed, 07 Feb 2018 12:15:14 GMT

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