Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
MCANTAL1639145723
Contributor
Contributor

Compare String Greater Than or Between in TMAP

Hi,

I have a data string that contains number and I need to know if the value is between 2 string values.

For example the data are :

"0265"

"0450"

"2351"

"1250"

"0315"

And I only want datas between "0000" and "0430"

In TMAP I don't know how to do, can someone help me ?

Thanks

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable

try this

(Integer.valueOf(row1.columnName)>=0&&Integer.valueOf(row1.columnName)<=430)?true:false

 

 

View solution in original post

1 Reply
Anonymous
Not applicable

try this

(Integer.valueOf(row1.columnName)>=0&&Integer.valueOf(row1.columnName)<=430)?true:false