topic Re: wild match in QlikView

wild match

nevilledhamsiri — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: wild match

Anil_Babu_Samineni — Thu, 09 Nov 2017 06:21:30 GMT

What are you trying here for highlight values?

Re: wild match

techvarun — Thu, 09 Nov 2017 06:57:35 GMT

What is the condition to select names?

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

Re: wild match

nevilledhamsiri — Thu, 09 Nov 2017 18:03:14 GMT

I need all names colourded in yellow to be highlighted

Re: wild match

nevilledhamsiri — Sat, 11 Nov 2017 09:48:59 GMT

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

Neville

Re: wild match

nevilledhamsiri — Sat, 11 Nov 2017 14:45:52 GMT

Please look in to this

Regds

Neville

Re: wild match

nevilledhamsiri — Wed, 15 Nov 2017 16:43:36 GMT

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

Re: wild match

vishsaggi — Wed, 15 Nov 2017 16:50:31 GMT

What is the criteria to search only those names?

And why this name is not highlighted - ?

K.T.UPASENA

Re: wild match

nevilledhamsiri — Wed, 15 Nov 2017 16:58:37 GMT

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.

Re: wild match

vishsaggi — Wed, 15 Nov 2017 17:02:05 GMT

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.

Re: wild match

nevilledhamsiri — Wed, 15 Nov 2017 17:20:48 GMT

The customer I am searching for ends up his name with term Upasena. But the data entry officer has entered this differently. at times with Mr, Mrs. T, K.D etc, Silveray is not in his name but he is the owner. You forget about all that for the moment and show me an expression to pick what ends up with upasena & add some logic to excludes other than Mr, Mrs, T, K.D. Just forget about Sivary as its is completely in different name.

MR.UPSENA

UPASENA

T.UPASENA

K.T.UPASENA

MRS.UPASENA

T.UPASENA

SILVARAY

K.D.UPASENA

Re: wild match

vishsaggi — Wed, 15 Nov 2017 17:38:02 GMT

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);

Re: wild match

nevilledhamsiri — Thu, 16 Nov 2017 17:17:44 GMT

Thanks Vishwarath

Almost close, If I need to add some more names (such as say K.D.S.S.R.UPASENA, N.UPASENA & so on, how this expression to be modified. since we have already given name upasena in to the expression does the expression automatically pick them?

Regds

Neville

Re: wild match

vishsaggi — Thu, 16 Nov 2017 17:23:37 GMT

Yes, it should pick them. The only names that will not be picked are the names that start with K.T. as you can see in the Not Wildmatch expression.

Re: wild match

nevilledhamsiri — Thu, 16 Nov 2017 17:51:44 GMT

Thanks Vishwanath for tame taken to resolve my issue!

Best Regards

Neville

Re: wild match

vishsaggi — Thu, 16 Nov 2017 18:24:36 GMT

No problem.