store expression into variable

[#1]

hi i have a scenario in this i need to store expression into variable but the expression gives to values in that i want only one value

plzz help me

this is the expression

=not WildMatch(F_Quarter,'*Q1')

it is displaying 2 values 0 and -1 i want to store this expression into variable

[ariel_klien]

Hi,

Did you try to use SET?

SET vMyVariable=' not WildMatch(F_Quarter,'*Q1')';

Ariel

[sushil353]

Hi,

go to settings> Variable overview

Click on add > give variable name and then click on that variable and in definition box give your expression;

=not WildMatch(F_Quarter,'*Q1')

HTH

Sushil

[jonathandienst · Accepted solution]

Are you planning to use this in a chart or table? If yes, make sure that it is stored without the leading = sign. Ariel Klein's suggestion is correct, except that you need to escape the single quotes like this:

Set vVar = 'not WildMatch(F_Quarter,''*Q1'')';

Use the expression in a $ expansion. Provide more details about your use of the variable for more specific help.

If you are planning to use this in a context where F_Quarter has more than one possible value, then this expression (and consequently the variable) will not work as there is no way to determine which F_Quarter value to test. You will need an aggregate function (like Max(), Min() etc). I suggest you provide more information about what you are trying to achieve.