Qlik Community

App Development

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

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Aspiring_Developer
Creator II
Creator II

Condition for matching 5th ND 6TH RECORD

 Hi ,

 

I have  a below field as :-

FKSTL_PRPS

0000080000

0000000010

CZ010812

CZ019011

 

I want to get only those ID's whose 5th and 6th records a= *08*

Can anyone please help ?

1 Solution

Accepted Solutions
lironbaram
Partner
Partner

you can use this 

FKSTL_PRPS

0000080000

0000000010

CZ010812

CZ019011

where mid(FKSTL_PRPS,5,2) = '08'

View solution in original post

1 Reply
lironbaram
Partner
Partner

you can use this 

FKSTL_PRPS

0000080000

0000000010

CZ010812

CZ019011

where mid(FKSTL_PRPS,5,2) = '08'

View solution in original post