topic Re: Enter More Than One String Value In A Variable in App Development

Enter More Than One String Value In A Variable

Rafal42 — Mon, 13 May 2024 20:18:48 GMT

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.

Re: Enter More Than One String Value In A Variable

marcus_sommer — Tue, 14 May 2024 07:36:21 GMT

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

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

Re: Enter More Than One String Value In A Variable

MarcoWedel — Tue, 14 May 2024 07:41:06 GMT

Hi, one example:

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

Re: Enter More Than One String Value In A Variable

Rafal42 — Tue, 14 May 2024 16:00:33 GMT

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

Re: Enter More Than One String Value In A Variable

marcus_sommer — Tue, 14 May 2024 16:09:16 GMT

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.