Equivalent function to Lookup but for charts

stascher — Mon, 31 Oct 2022 15:14:09 GMT

Hello,

Given a table similar to the following:

location	favorite_fruit
Home	Apple
Office	Apple

I would expect to be able to use the following expressions:

=fieldvalue('favorite_fruit',fieldindex('location','Home')) or

=fieldvalue('favorite_fruit',fieldindex('location','Office'))

This works fine if the favorite_fruit values are unique, but if they're the same, fieldvalue() regards favorite_fruit as having only 1 value and thus =fieldvalue('favorite_fruit',fieldindex('location','Office')) returns null.

Is there any expression that would return the favorite_fruit value for Office regardless of non-unique values?

Thanks,

Steve

Re: Equivalent function to Lookup but for charts

vinieme12 — Tue, 01 Nov 2022 02:56:45 GMT

why not use a MaxString() ??

MaxString({<location={'Office'}>}favorite_fruit)

topic Equivalent function to Lookup but for charts in App Development

Equivalent function to Lookup but for charts

Re: Equivalent function to Lookup but for charts