topic Random numbers creation? in QlikView https://community.qlik.com/t5/QlikView/Random-numbers-creation/m-p/1101712#M904896 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>How can I randomly assign either 2 or 3 to a field? I know I have to use rand() function but not sure how to make it only assign 2 and 3</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Random numbers creation? https://community.qlik.com/t5/QlikView/Random-numbers-creation/m-p/1101712#M904896 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>How can I randomly assign either 2 or 3 to a field? I know I have to use rand() function but not sure how to make it only assign 2 and 3</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Random-numbers-creation/m-p/1101712#M904896 2020-11-25T16:16:04Z Re: Random numbers creation? https://community.qlik.com/t5/QlikView/Random-numbers-creation/m-p/1101713#M904897 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P><STRONG>If(Rand() &lt; 0.5, 2, 3)</STRONG></P></BODY></HTML> Thu, 23 Jun 2016 13:03:55 GMT https://community.qlik.com/t5/QlikView/Random-numbers-creation/m-p/1101713#M904897 sunny_talwar 2016-06-23T13:03:55Z Re: Random numbers creation? https://community.qlik.com/t5/QlikView/Random-numbers-creation/m-p/1101714#M904898 <HTML><HEAD></HEAD><BODY><P>or</P><P></P><P><STRONG>If(Rand() &lt;= 0.5, 2, 3)</STRONG></P></BODY></HTML> Thu, 23 Jun 2016 13:04:13 GMT https://community.qlik.com/t5/QlikView/Random-numbers-creation/m-p/1101714#M904898 sunny_talwar 2016-06-23T13:04:13Z Re: Random numbers creation? https://community.qlik.com/t5/QlikView/Random-numbers-creation/m-p/1101715#M904899 <HTML><HEAD></HEAD><BODY><P>Just an idea:</P><P></P><P>Insert a Row number in your table and based on the row number (Whether it is even or odd) assign either 2 or 3 to your field...</P></BODY></HTML> Thu, 23 Jun 2016 13:05:39 GMT https://community.qlik.com/t5/QlikView/Random-numbers-creation/m-p/1101715#M904899 trdandamudi 2016-06-23T13:05:39Z