Dynamic String Find in Field - Frontend Calculation

[zwilson_borg]

I'm looking for a way to dynamically search a field on the front end to see if all the values have a shared sequence. I don't want to provide it to search but rather it is found dynamically. For example, if I had the below data and the application is filtered to 'A' on [Grp] it would return 'SMTH - ' but unfiltered it would return '' or Null().

Grp | Text Value

  A   |  SMTH - 1E

  A   |  SMTH - 2W

  B  |   WPQV - 2A

  B  |  5N

Thanks in advance for your help/thoughts.

[MayilVahanan]

Hi,

Do you want to display the text value in the KPI? 

If so, try like below

=If(GetSelectedCount(Grp)=1, Concat(Distinct [Text Value], ','), '')

[zwilson_borg]

Mayil,

I need it to return the substring that is shared across each possible value in the field. In the example, I need the KPI box to just show 'SMTH - '. Your expression instead returns 'SMTH - 1E,SMTH - 2W'

[marcus_sommer · Accepted solution]

Just taking a subfield-information maybe like this:

If(GetSelectedCount(Grp)=1, Concat(Distinct subfield([Text Value], ' - ', 1), ','), '')

- Marcus