Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

tkendrick20
Valued Contributor

Select a Field Based on Another Field

I get an error "Error in Expression: ')' expected" but I can't figure out where I'm going wrong.

=GetFieldSelections({1<Organization_Name=$vOrgName>} Organization_ID)

Each Organization_Name has a unique Organization_ID and vice versa. I just want to return the ID of an organization via a variable that holds the Organization_Name as a string.

Thanks in advance!

1 Reply
Not applicable

Re: Select a Field Based on Another Field

TRY with this:

=only({1<Organization_Name={'$(vOrgName)'}>} Organization_ID)


Mc

Community Browser