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

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
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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.

Labels (1)
Labels
3,873 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

3,492 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.
3,493 Views
0 Likes