topic (IF) Statement With Number Range in QlikView https://community.qlik.com/t5/QlikView/IF-Statement-With-Number-Range/m-p/388703#M145079 <HTML><HEAD></HEAD><BODY><P>I have a list of codes 1000-5000. I want to <SPAN style="color: #0000ff;">load </SPAN>codes 2000-3500 <SPAN style="color: #0000ff;">as</SPAN> "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. </P></BODY></HTML> Wed, 28 Nov 2012 21:12:25 GMT MalcolmCICWF 2012-11-28T21:12:25Z (IF) Statement With Number Range https://community.qlik.com/t5/QlikView/IF-Statement-With-Number-Range/m-p/388703#M145079 <HTML><HEAD></HEAD><BODY><P>I have a list of codes 1000-5000. I want to <SPAN style="color: #0000ff;">load </SPAN>codes 2000-3500 <SPAN style="color: #0000ff;">as</SPAN> "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. </P></BODY></HTML> Wed, 28 Nov 2012 21:12:25 GMT https://community.qlik.com/t5/QlikView/IF-Statement-With-Number-Range/m-p/388703#M145079 MalcolmCICWF 2012-11-28T21:12:25Z Re: (IF) Statement With Number Range https://community.qlik.com/t5/QlikView/IF-Statement-With-Number-Range/m-p/388704#M145080 <HTML><HEAD></HEAD><BODY><P>HI </P><P></P><P>Try like this</P><P></P><P>Load *,</P><P>If(Codes &gt;=2000 and Codes&lt;=3500,Codes) as Label from tablename;</P><P></P><P>Hope it helps</P></BODY></HTML> Wed, 28 Nov 2012 21:14:47 GMT https://community.qlik.com/t5/QlikView/IF-Statement-With-Number-Range/m-p/388704#M145080 MayilVahanan 2012-11-28T21:14:47Z