topic Re: Scripting between in QlikView https://community.qlik.com/t5/QlikView/Scripting-between/m-p/1104364#M365857 <HTML><HEAD></HEAD><BODY><P>One more version..</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_1463686693012434" jivemacro_uid="_1463686693012434" modifiedtitle="true"> <P>Load *, Pick(Match(-1,(Gates &gt; 10 And Gates &lt;= 999),Gates &gt; 999,Gates&lt;=10),'Low','High','N/A') As Score;</P> <P>Load * Inline [</P> <P>Gates</P> <P>11</P> <P>1000</P> <P>9</P> <P>];</P> </PRE></BODY></HTML> Thu, 19 May 2016 19:38:45 GMT Saravanan_Desingh 2016-05-19T19:38:45Z Scripting between https://community.qlik.com/t5/QlikView/Scripting-between/m-p/1104362#M365855 <HTML><HEAD></HEAD><BODY><P>How can I add an extra column in my data to say if the score is high or low. So i have a column called Gates and i need to produce a new column called Score in which i need to put high or low depending on the score. So anything &gt;10 but &lt;999 needs to say Low and anything &gt;999 needs to say High.</P></BODY></HTML> Thu, 19 May 2016 14:18:38 GMT https://community.qlik.com/t5/QlikView/Scripting-between/m-p/1104362#M365855 kevbrown 2016-05-19T14:18:38Z Re: Scripting between https://community.qlik.com/t5/QlikView/Scripting-between/m-p/1104363#M365856 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P><STRONG>LOAD Gates,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If(Gates &gt; 10 and Gates &lt;= 999, 'Low',</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If(Gates &gt; 999, 'High', 'N/A')) as Score</STRONG></P><P><STRONG>FROM Source;</STRONG></P></BODY></HTML> Thu, 19 May 2016 14:20:48 GMT https://community.qlik.com/t5/QlikView/Scripting-between/m-p/1104363#M365856 sunny_talwar 2016-05-19T14:20:48Z Re: Scripting between https://community.qlik.com/t5/QlikView/Scripting-between/m-p/1104364#M365857 <HTML><HEAD></HEAD><BODY><P>One more version..</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_1463686693012434" jivemacro_uid="_1463686693012434" modifiedtitle="true"> <P>Load *, Pick(Match(-1,(Gates &gt; 10 And Gates &lt;= 999),Gates &gt; 999,Gates&lt;=10),'Low','High','N/A') As Score;</P> <P>Load * Inline [</P> <P>Gates</P> <P>11</P> <P>1000</P> <P>9</P> <P>];</P> </PRE></BODY></HTML> Thu, 19 May 2016 19:38:45 GMT https://community.qlik.com/t5/QlikView/Scripting-between/m-p/1104364#M365857 Saravanan_Desingh 2016-05-19T19:38:45Z Re: Scripting between https://community.qlik.com/t5/QlikView/Scripting-between/m-p/1104365#M365858 <HTML><HEAD></HEAD><BODY><P>Nice, looks good. Thanks for sharing this <A _jive_internal="true" href="https://community.qlik.com/people/saran7de">saran7de</A></P></BODY></HTML> Thu, 19 May 2016 19:40:59 GMT https://community.qlik.com/t5/QlikView/Scripting-between/m-p/1104365#M365858 sunny_talwar 2016-05-19T19:40:59Z Re: Scripting between https://community.qlik.com/t5/QlikView/Scripting-between/m-p/1104366#M365859 <HTML><HEAD></HEAD><BODY><P>I'm proud. A word from <STRONG style="color: #252525; font-family: sans-serif; font-size: 14px;">Vashishtha</STRONG><SPAN style="color: #252525; font-family: sans-serif; font-size: 14px;"> <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></SPAN></P></BODY></HTML> Thu, 19 May 2016 19:58:14 GMT https://community.qlik.com/t5/QlikView/Scripting-between/m-p/1104366#M365859 Saravanan_Desingh 2016-05-19T19:58:14Z