App Development

[ajit_aarya]

I want to select only specified values in my field

As example 

Code

USFYKAU8I

USIKSAU9U

USKJ1SHSW

I want only codes which start with US and sixth letter should be A.

I tried this   =If(WildMatch(Code,'US***A***'), Code)

but its giving all fields which has U,S,A in the code and i need only sixth letter A

#expressions #logi

[rwunderlich · Accepted solution]

Use the ? wildcard which indicates a single character.

=If(WildMatch(Code,'US???A???'), Code)

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[ajit_aarya]

That works, Thanks