Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Highlighted
Partner
Partner

Search for a number in a field

Hi,

In a field I have a string of numbers like this:

0111111011111000000000000000000000000000000000000000

Is there an expression that can help me to find that in this row the number 1 is on 2nd, 3rd etc place in this string?

Thank you for your help!

T.

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Search for a number in a field

You can try using the mid function. To check if the second character is a 1: if(mid(MyString, 2,1)='1', 'Match', 'No Match')

Or to check three 1's starting from position two:  if(mid(MyString, 2,3)='111', 'Match', 'No Match')


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Search for a number in a field

You can try using the mid function. To check if the second character is a 1: if(mid(MyString, 2,1)='1', 'Match', 'No Match')

Or to check three 1's starting from position two:  if(mid(MyString, 2,3)='111', 'Match', 'No Match')


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Partner
Partner

Re: Search for a number in a field

Thank you! Works great!