topic Re: match and wildmatch behaviour in QlikView

match and wildmatch behaviour

konidena — Mon, 14 Sep 2015 05:59:47 GMT

Hi All,

Please help me in getting clarified wildmatch behaviour.

Here is the example

I have used inline statement with the field name as system_result

values of the field are

An error has occurred

Error processing account nnnn

i have loaded this inline statement in the script and added this field to main sheet.

I have created the text box with the the text as "=wildmatch(system_result,'*occurred*')"

As per the wildmatch behaviour, what the text object should display here

If i use "=match(system_result,'An error has occurred'), what the text object should display.

In my case, it is showing the '-' symbol

Re: match and wildmatch behaviour

sunny_talwar — Mon, 14 Sep 2015 09:03:07 GMT

Try this may be:

=If(WildMatch(system_result,'*occurred*'), system_result)

Re: match and wildmatch behaviour

qlikmsg4u — Mon, 14 Sep 2015 09:06:06 GMT

Or may be, it returns system_result where occurrence of occurred is only one

=Only(If(wildmatch(system_result,'*occurred*'),system_result))

Re: match and wildmatch behaviour

Anonymous — Mon, 14 Sep 2015 09:11:17 GMT

hi srinivas,

use below syntax in straight table :

=If(WildMatch(system_result,'*occurred*'), system_result)

text box will not display any text unless a relevant field is selected

Re: match and wildmatch behaviour

tripatirao — Mon, 14 Sep 2015 10:50:37 GMT

Hi Srinivas

this is the syntax for wildmatch function

wildmatch( str, expr1 [ , expr2,...exprN ] )

The wildmatch function performs a case insensitive comparison and permits the use of wildcard characters ( * and ?) in the comparison strings.

Example:

wildmatch( M, 'ja*','fe?','mar')

returns 1 if M = January

returns 2 if M = fex

and check with this

wildmatch(An error has occurred,'*occurred*')

Re: match and wildmatch behaviour

maxgro — Mon, 14 Sep 2015 11:04:24 GMT

As per the wildmatch behaviour, what the text object should display here

If i use "=match(system_result,'An error has occurred'), what the text object should display.

it depends on what your select in system_result

for 1 values of system_result you get an answer (0,1), for different values you get -

Re: match and wildmatch behaviour

sasiparupudi1 — Mon, 14 Sep 2015 13:44:55 GMT

please share a sample

Re: match and wildmatch behaviour

konidena — Tue, 15 Sep 2015 14:20:02 GMT

Thanks sunny for your reply.

Re: match and wildmatch behaviour

konidena — Tue, 15 Sep 2015 14:48:50 GMT

Thanks neetha for your valid reply.

when I selected the value in the field "system_result", the text box is showing the relevant text.

What is the straight table here?. Please add me to this knowledge.

Also, if you have idea on Peek and previous functions functionality, please explain me with valid real time scenario.

Here is what i know about the peek() and Previous().

Previous() operates on the Input to the Load statement, whereas Peek() operates on the Output of the Load statement.

Peek('employee count',0) returns the first row in the table

Peek('employee count',-1) returns the last row in the table

Peek('employee count') also returns the last row. It means that, if row number not specified, it returns the last row.

Question: Peek() is saying the returns of data based on the mentioned row value. Where exactly we use this peek and Previous functions?

It will be great if you provided the Peek() and Previous() functions example clearly to raise my knowledge.

Re: match and wildmatch behaviour

konidena — Tue, 15 Sep 2015 14:50:23 GMT

Thanks tripati rao for your clear reply.

Re: match and wildmatch behaviour

konidena — Tue, 15 Sep 2015 14:53:33 GMT

sasidhar, i had provided the sample data in my query itself.

thanks much for your patience on my query.

Re: match and wildmatch behaviour

MarcoWedel — Tue, 15 Sep 2015 22:29:14 GMT

Hi,

when comparing with only one string, you could as well use the like operator instead of the wildmatch function:

hope this helps

regards

Marco