topic Re: Dynamic Variable Name in App Development

Dynamic Variable Name

m_perreault — Fri, 01 Jun 2018 14:28:38 GMT

Hi All,

Say I have data for 3 countries, USA, UK, and Canada and I set three variables.

vUSAScaling = .1

vUKScaling = .2

vCanadaScaling = .3

I'd like to have a measure that is

sum(Sales) * $(vCountryScaling) and have the value of vCountryScaling reflect my selection for country. I have tried doing something like $('v$(=GetFieldSelections(Fund))Scaling') but have not had any luck. Does anyone have any ideas?

Thanks!

Mark

Re: Dynamic Variable Name

m_perreault — Fri, 01 Jun 2018 14:38:47 GMT

I figured out part of it

$(=Concat('v' & getfieldselections(country) & 'Scaling'))

will work but now I am running into a different issue. I want to have a table like below with my measure using the dynamic variable but since I am not making selections it will not work. I have tried using $(=concat('v' & concat(distint Country) & 'Scaling')) but it is not working.

Country ScaledSales

USA sum(Sales) * $(=Concat('v' & getfieldselections(country) & 'Scaling'))

Canada

Thanks!

Re: Dynamic Variable Name

prat1507 — Fri, 01 Jun 2018 14:55:13 GMT

Please see the attached app for your reference.

Regards
Pratyush

Re: Dynamic Variable Name

m_perreault — Fri, 01 Jun 2018 15:20:09 GMT

Thank you Pratyush, I apologize I am not able to download qvw's at this time would you be able to send a screenshot of what you did?

Re: Dynamic Variable Name

prat1507 — Fri, 01 Jun 2018 15:39:14 GMT

Re: Dynamic Variable Name

m_perreault — Fri, 01 Jun 2018 15:46:30 GMT

Perfect thank you!