Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi...
I am new to learn..
please any one help me..
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.