topic Re: Qlikview WildMatch Function in QlikView

Qlikview WildMatch Function

kashjaniqlik — Mon, 15 Dec 2014 10:36:25 GMT

Hello

I have a requirement to search for a word in a string and get a count of these words. The problem I'm facing is to find the exact word in a string that matches exactly as per my criteria.

For e.g let's assume I have below text in a column and I would like to only find "Conduct"

Column 1

Conducted

Conduct

Conduction

With below code, it will return all three rows and I someone need to find only second row (Conduct)

Filter:

Load
Column as Column1,
If (WildMatch(Column, '*conduct*') = 1,'Y','N') AS Conduct
Resident WildMatch

Thanks

Re: Qlikview WildMatch Function

PrashantSangle — Mon, 15 Dec 2014 10:40:14 GMT

Hi,

Dont use wild character like *

Try like

If(Wildmatch(Column,'conduct'),'Y','N')

if you need case sensative search then try with match()

If(Wildmatch(Column,'Conduct'),'Y','N')

Regards

Re: Qlikview WildMatch Function

kashjaniqlik — Mon, 15 Dec 2014 10:43:57 GMT

Apologies, I should have mention this in my original thread.

The text is part of a larger text hence I will need to use the wildmatch as conduct is buried inside the long string.

This is the complete code. If I don't use WildMatch here then it won't find Conduct text

WildMatch:

Load * Inline
[
Column
Test conduct test1
test2 Conducted test3
test4 conduction test5
];

Filter:
Load
Column as Column1,
If (WildMatch(Column, 'conduct') = 1,'Y','N') AS Conduct

Resident WildMatch

Re: Qlikview WildMatch Function

rajeshvaswani77 — Mon, 15 Dec 2014 10:44:21 GMT

You can use match function instead of wildmatch and without wild cards. The match function is however case sensitive.

thanks,

Rajesh Vaswani

Re: Qlikview WildMatch Function

PrashantSangle — Mon, 15 Dec 2014 10:54:43 GMT

Hi,

Try with including spaces

try like

If(Wildmatch(Column,'* conduct *'),'Y','N')

Regards

Re: Qlikview WildMatch Function

kashjaniqlik — Mon, 15 Dec 2014 11:10:43 GMT

Great. Thanks very much Max.

I also find some text in my string starting & ending with conduct text and above solution will not pick up these strings but managed to work it out based on your solution so thanks anyway.

(WildMatch([Issue Title], '* conduct *') = 1 or WildMatch([Issue Title], 'conduct *') or WildMatch([Issue Title], '* conduct'),'Y','N') AS Conduct,

Re: Qlikview WildMatch Function

PrashantSangle — Mon, 15 Dec 2014 11:46:40 GMT

Hi,

One more advice there is no need to write multiple wildmatch()

You acheive it in on wildmatch() also

Try like

If(Wildmatch(Column,'* conduct *','conduct *','*conduct '),'Y','N')

Regards