Variable Input

[vStefano]

Good morning,

I am new to Qlik sense and I am trying to setting up a dashboard with changing measures. Precisely I want calculated measures to change based on the selected value of a variable (the values of the variable are the names of the primary measures). 

The primary measures are €,KG and SQM. I use these measures to create calculated ones such as: €2021, €2020, SQM 2020, SQM 2021 etc. What I want is to use a unique formula to calculate 2021 (€2021, M2 2021 etc) and 2020 values according the value of the variable selected. I have there for changed the original formula like this:

In the attached word file I explain step by step.

Can some one tell me what I am doing wrong?

[GaryGiles · Accepted solution]

You want to enclose the variable in a $ expansion in your expression.

use $(vMeasure) in the expression instead of just vMeasure.

[vStefano]

Thanks Gary, I had already tried to enclose the variable but it did not worked initially. I have then found the issue.

In addition to closing the variable (your solution is right) I needed to change the variabile taking out the = symbol

Regards,

Stefano