Setting a variable based on another variable

nix1 — Thu, 15 Jul 2021 13:00:37 GMT

I have set up two variables in the variables overview of my sheet.

Selected_City =only({<City = {$(Selected_City)}>} )

Selected_Region==only({<City={$(Selected_City)}>} Region)

This is so I can compare city progress to regional progress to global progress in a graph.

However, when my selected city is a string with a space (e.g. Hong Kong) the selected_region variable doesn't work.

Is there anyway I can get it to recognise the string?

Re: Setting a variable based on another variable

PrashantSangle — Thu, 15 Jul 2021 13:55:34 GMT

hi,

try with double quote for that

Selected_Region==only({<City={"=$(Selected_City)"}>} Region)