Use of variables in Set Analysis

[#1]

I feel I'm missing something very obvious here. Can someone please tell me the difference between these two expressions?

This expression returns data:

Count({<MATTER.MATTER_OPEN_YEAR={'2014'}>} MATTER.CLNT_MATT_CODE)

This expression does not. The currentYear variable contains the value '2014', which I have confirmed by displaying the contents in a text box. The expression editor shows no errors.

Count({<MATTER.MATTER_OPEN_YEAR={$(currentYear)}>} MATTER.CLNT_MATT_CODE)

Many thanks, Gavin

[#2 · Accepted solution]

well, I would use the equal sign + double quotes. Sth like (but not tested):

Count({<MATTER.MATTER_OPEN_YEAR={“= $(currentYear)”}>} MATTER.CLNT_MATT_CODE)

Fabrice

[#3]

Hi Michael,

Unfortunately the file is very large - I'm not sure if the screenshots below will help?

currentPeriod variable:

currentYear variable:

textbox to verify:

Chart + formula with hardcoded '2014':

Chart + formula with currentYear variable (have tried with single, double and no quotes):

Thanks, Gavin

[#4]

Hi Alessandro - That returns a 'Y':

(Please also see the just-attached screenshots above)

Thanks, Gavin

[#5]

Thank you Aunez. The use of double quotes, plus the extra = sign within them, works, i.e.:

Count({<MATTER.MATTER_OPEN_YEAR={"=$(currentYear)"}>} MATTER.CLNT_MATT_CODE)

Gavin

[Anonymous]

Gavin,

Explanation of the problem and the solution:

Your variable content is not '2014' - it is expression 'left($(currentPeriod),4)'.  The text box to verify had to be
=currentYear

That's why the solution from AUNEZ FABRICE resolved the problem by adding "=" before the variable.

Regards,

Michael

PS: Regarding file upload - you can always use "data reduction" and scrambling.