Variable with set analysis and a string parameter

[#1]

Hello,

I try to make a variable which contains a set analysis and a parameter in it.  After I put an expression in my chart with that variable but it does not work.

My variable vTest contains:   =Only({1<Code_Measures_et_Time={$1}>} Time_Label)

In my chart I put this expression in the expression label : =$(vTest(101_1001))

My parameter is a string : 101_1001

What am I doing wrong?

Thank you!

Patrick

[Peter_Cammaert]

Maybe try

=Only({1<Code_Measures_et_Time={'$1'}>} Time_Label)

(note the quotes). If you fill the variable with a LET statement, use chr(39) function calls to insert the quotes in a string.

Peter.

[#3]

Thanks but I already tried that and it didn't help.

[#4 · Accepted solution]

I found the answer myself:

My variable vTest must contains (i removed the equal sign

in my variable:   Only({1<Code_Measures_et_Time={$1}>} Time_Label)

This way my variable doesn't recalculate before having my parameter I think.

In my chart I put this expression in the expression label :  =$(vTest(101_1001))

But because I have a formula in my variable that need to be evaluated I added "=$(" in front and ")" at end : =$(=$(vTest(101_1001)))

[Peter_Cammaert]

You're right, should have seen that. It's a common mistake that makes chart expressions fall over. Good deduction.

[lightsection]

Is there a way to put multiple string in a single parameter ?

For eg:

Expression:

Let vE_Sales = sum({<Year = {$1}>} Sales);

When calling this expression we say

$(vE_Sales('2016'))

But if I wanted to do the same for multiple years. Let say 2016 & 2015. how do we do pass multiple string values in a single parameter ?

$(vE_Sales('2016', '2015'))