Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Nagaraju_KCS
Specialist III
Specialist III

use of wildmatch and firstsortedvalue

Hi...

I am new to learn..

please any one help me..

1 Reply
jagan
Partner - Champion III
Partner - Champion III

HI,

Check this link (http://community.qlik.com/message/307004#307004) for firstsortedvalue.

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

* is used for multiple characters

? is used for single character

Example:

wildmatch( M, 'ja*','fe?','mar')  // In this 'ja*', the first two characters should be ja Or JA, for 'fe?' the first 2 characters should be fe and third character should be of any character.

returns 1 if M = January

returns 2 if M = fex

You can try all this by pasting the expression using Text box object.

=wildmatch( 'January', 'ja*','fe?','mar')

=wildmatch( 'fex', 'ja*','fe?','mar')

Hope this helps you.

Regards,

Jagan.