topic Re: Wild Match ? in QlikView

Wild Match ?

Thu, 06 Mar 2014 13:06:03 GMT

In how many ways we can use this ...

Re: Wild Match ?

Anonymous — Thu, 06 Mar 2014 13:08:49 GMT

Helen

I always the QV Desktop Help useful for explaing QV functions. I have pasted the below in from it.

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

Best Regards, Bill

Re: Wild Match ?

MK_QSL — Thu, 06 Mar 2014 13:09:46 GMT

Try below code...

T1:

Load * Inline

[

id1, id2, value

AAA, 1, 100

BAC, 2, 120

CDA, 3, 140

]Where WildMatch(id1,'A?*','B*');

Re: Wild Match ?

Thu, 06 Mar 2014 13:15:23 GMT

Thanks Bill

But it was the Syntax, how can we use in different ways ? & Use..

I am not getting clear..

Re: Wild Match ?

Thu, 06 Mar 2014 13:19:50 GMT

GIve me some more clarity on this..

Re: Re: Wild Match ?

MK_QSL — Thu, 06 Mar 2014 13:26:40 GMT

Please check enclosed file.

I have used three different places.

1) In the script itself to restrict the full load

2) in the TABROW, once you select the tab (sheet) at the top, the color will change. Go inside the Sheet Properties and Color section to find out how this is happenning.

3) in the text box.... according to you selection on ID1, you will get answer Yes or No.

Hope this will helps.

Re: Wild Match ?

Thu, 06 Mar 2014 13:30:21 GMT

Helen, this is your second question now where you have been very vague. Please provide more information on why you want to know, what you are trying to do.

Also this forum has a lot of information and examples on this topic. Please search the forums for required information before posting

Kind Regards,

Byron

Re: Re: Wild Match ?

sunilkumarqv — Thu, 06 Mar 2014 13:32:35 GMT

Hi,

Let check attached file you get to know

Hope these helps you