Select a Field Based on Another Field

TKendrick20 — Tue, 11 Mar 2014 22:52:15 GMT

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!

Re: Select a Field Based on Another Field

Tue, 11 Mar 2014 22:56:14 GMT

TRY with this:

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

topic Select a Field Based on Another Field in QlikView

Select a Field Based on Another Field

Re: Select a Field Based on Another Field