Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
ajit_aarya
Contributor
Contributor

Filtering with respect to specified position in the value of a field

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

Labels (2)
1 Solution

Accepted Solutions
rwunderlich

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

View solution in original post

2 Replies
rwunderlich

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
Contributor
Contributor
Author

That works, Thanks