Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
MalcolmCICWF
Creator III
Creator III
‎2012-11-28 04:12 PM

(IF) Statement With Number Range

I have a list of codes 1000-5000. I want to load codes 2000-3500 as "Label". How could I write this out without doing a Mixmatch and listing all the codes I want or do not want? I believe it is some sort of "IF" statement, but I am not sure how to write it out.

3,312 Views
0 Likes
1 Solution

Accepted Solutions
MayilVahanan
MVP
MVP
‎2012-11-28 04:14 PM

HI

Try like this

Load *,

If(Codes >=2000 and Codes<=3500,Codes) as Label from tablename;

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

2,931 Views
0 Likes
1 Reply
MayilVahanan
MVP
MVP
‎2012-11-28 04:14 PM

HI

Try like this

Load *,

If(Codes >=2000 and Codes<=3500,Codes) as Label from tablename;

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
2,932 Views
0 Likes