Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Just taking a subfield-information maybe like this:
If(GetSelectedCount(Grp)=1, Concat(Distinct subfield([Text Value], ' - ', 1), ','), '')
- Marcus
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], ','), '')
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'
Just taking a subfield-information maybe like this:
If(GetSelectedCount(Grp)=1, Concat(Distinct subfield([Text Value], ' - ', 1), ','), '')
- Marcus