Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Wild Match ?

In how many ways we can use this ...

7 Replies
Anonymous
Not applicable
Author

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

MK_QSL
MVP
MVP

Try below code...

T1:  

Load * Inline

[                  

  id1, id2, value

  AAA, 1, 100

  BAC, 2, 120

  CDA, 3, 140

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

Not applicable
Author

Thanks Bill

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

I am not getting clear..

Not applicable
Author

GIve me some more clarity on this..

MK_QSL
MVP
MVP

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.

Not applicable
Author

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

sunilkumarqv
Specialist II
Specialist II

Hi,

Let check attached file you get to know

Hope these helps you