topic Re: store expression into variable in QlikView

store expression into variable

Mon, 27 Jul 2015 06:55:35 GMT

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

Re: store expression into variable

ariel_klien — Mon, 27 Jul 2015 07:01:36 GMT

Hi,

Did you try to use SET?

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

Ariel

Re: store expression into variable

sushil353 — Mon, 27 Jul 2015 07:04:49 GMT

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

Re: store expression into variable

jonathandienst — Mon, 27 Jul 2015 07:14:36 GMT

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.