Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
SR2
Contributor III
Contributor III

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

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

Labels (1)
  • SaaS

4 Replies
Chanty4u
MVP
MVP

try this

 

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

SR2
Contributor III
Contributor III
Author

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
MVP
MVP

How much data do you have in your field?

SR2
Contributor III
Contributor III
Author

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)