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

wild match

Hi

Please find my attachment & explain me how that may be done in a chart without being missed out even a single data. What is colored in yellow to be highlighted

When names are in different formats & need to get highlighted a set of data,

how it is highlighted in the script

how it is done as an expression

how it could be done in list box (Eg-Cust Name)

Thanks

Neville.

1 Solution

Accepted Solutions
vishsaggi
Champion III
Champion III

Try this?

LOAD CUSTOMER_NAME,

     PREMIUM,

     IF(Not WildMatch(CUSTOMER_NAME, '*K.T.*') AND WildMatch(CUSTOMER_NAME, '*Upasena*', '*Upsena*', 'SILVARAY'), CUSTOMER_NAME) AS ValidCust

    

FROM

CUST.xlsx

(ooxml, embedded labels, table is Sheet2);

View solution in original post

15 Replies
Anil_Babu_Samineni

What are you trying here for highlight values?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
techvarun
Specialist II
Specialist II

What is the condition to select names?

if you have only names and No conditions, you have to pick names manually

nevilledhamsiri
Specialist
Specialist
Author

I need all names colourded in yellow to be highlighted

nevilledhamsiri
Specialist
Specialist
Author

Please check my excel & what is coloured in Yellow to be picked at once. Please help me to achieve this!

Neville

nevilledhamsiri
Specialist
Specialist
Author

Please look in to this

Regds

Neville

nevilledhamsiri
Specialist
Specialist
Author

Dear Anil,

Please see the yellow coloured names in excel which I need to search for, Appreciate if you propose a search for this at once.

Regds

Neville

vishsaggi
Champion III
Champion III

What is the criteria to search only those names?

And why this name is not highlighted - ?

K.T.UPASENA
nevilledhamsiri
Specialist
Specialist
Author

Thanks Vishwarath for responding!

K.T.Upasena, though ends with term Upasena, he is not falling in to my group. Only those who are coloured in yellow.

vishsaggi
Champion III
Champion III

Need more info about that Group what you mean your group? Is there any other field that categorize that Group. Cos the information is insufficient to work on this logic rather than doing hardcode searching for these names if we have any specific rule it would be easy to work on.