Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
TKendrick20
Partner - Specialist
Partner - Specialist

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

TRY with this:

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


Mc