Enter More Than One String Value In A Variable

[Rafal42]

Hello,

I am trying to input more than one string in a variable and the best I could come with is this...

MATCH

(

    TITLE,

        'Engine Annual Requirements',

        'Transmission Annual Requirements',

        'Suspension Annual Requirements',

        'Exterior Annual Requirements',

)

I am creating this variable in the front end. It is called AnnualCertification, I want to use it in multiple KPIs. One such KPI would have set analysis like this...

COUNT({<CERTIFICATION_TITLE = {$(vAnnualCertification)}>} DISTINCT I_USR)

I am getting an error when I do this. What am I missing here? I have a feeling it's something minor. Thanks in advance.

[marcus_sommer]

Just listing the values within the variable is enough, like: var: 'a', 'b', 'c'

and then: count({< Field = {$(var)}>} Field)

[MarcoWedel]

Hi, one example:

vAnnualCertification = 'Engine Annual Requirements','Transmission Annual Requirements','Suspension Annual Requirements','Exterior Annual Requirements'

[Rafal42]

I always get an error when I insert more than one string in the variable.

[marcus_sommer · Accepted solution]

It's not a real error else the interpreter couldn't resolve the content as a single field, string, variable or a function - you could just ignore it.