Evaluate variable value from excel

[ashis]

Hi,

In my qliksense dashboard I have declared vCity variable like the syntax below and it perfectly works fine

vCity = IF($(vCountry)=0,'CityFlag={1}','CityFlag={2}')

Now I want to read this variable from excel sheet so in excel I wrote it like 

vCity  '= IF($(vCountry)=0,'CityFlag={1}','CityFlag={2}')' , like the image below

But it is not working, what syntax show I need to pass so that it can evaluate it value.

[Andrea_Spinetti]

Hi @ashis, I'm not sure I've fully understood your request. Why would you like to write the variable's formula in Excel? Is there a specific reason why you are trying to do so? Or do you want the variable to be exported as a usable formula in Excel? Feel free to add more details so I can better assist. Thanks!

[ashis]

HI Andrea,

Thank you for your reply.  I want to import all the variables from excel to QlikSense dashboard instead of making variables in the APP.

So my struggle is when I define a variable using "=", in the Application it works fine . Now I want same formula to read from excel . I am unable to pass the variable value with "=" . 

So when I see after importing variables from excel it is making the variable vCity as 

IF($(vCountry)=0,'CityFlag={1}','CityFlag={2}') where as I want to make it as 

= IF($(vCountry)=0,'CityFlag={1}','CityFlag={2}')

Thanks

[vchuprina · Accepted solution]

Hi, 

Cover your $(vCountry) variable into single quotes  and remove '=' and single quotes at the start and at the end of your expression 

Before:

'= IF($(vCountry)=0,'CityFlag={1}','CityFlag={2}')' 

After:

IF('$(vCountry)'=0,'CityFlag={1}','CityFlag={2}')

Regards,

Vitalii