QlikSense expression to find similar values (not exactly matching) in a table

[SR2]

Hello Talented people,

I am wondering if there a feature in QS to find similar values in a table.

Example - if a dimension has following values then can I  identify / highlight first 2 rows as the strings are exactly matching except for the last one character.

Apple_2020_1
Apple_2020_2
Mango2020_f1
Mango2021_p
Mytextabc
11textxyz

PS - I do not know the pattern that I want to match as the values are quite diverse. I just want to identify values which have an exact matching value present in this dimension except for last 1 or 2 characters in them.

Many Thanks,

Sumeer

[Chanty4u]

try this

=if(count( Total <Yourfield> yourfield) > 1 , LightGreen())

[SR2]

Thank you for your quick reply. I now tried this one but it does not work. 

I could not understand what this expression is doing. Values I expect to be highlighted in my table are follows -

17/02-23/02/20C
17/02-23/02/20B
17/02-23/02/20A

As you see only last character is different in all these strings.

Best Regards,

Sumeer

[Chanty4u]

How much data do you have in your field?

[SR2]

After applying filters the table has 48 rows otherwise the row count is in multiple thousands. But I expect this formula to work on limited rows only which is after I apply filters (i.e. I will be good to few hundreds)