topic Re: Create Random Negative and Positive Values in QlikView https://community.qlik.com/t5/QlikView/Create-Random-Negative-and-Positive-Values/m-p/1146504#M908093 <HTML><HEAD></HEAD><BODY><P>rand()*40-15</P></BODY></HTML> Sat, 18 Jun 2016 03:05:20 GMT nagaiank 2016-06-18T03:05:20Z Create Random Negative and Positive Values https://community.qlik.com/t5/QlikView/Create-Random-Negative-and-Positive-Values/m-p/1146502#M908091 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>Need to create random values -15% to +25% of sales Column, Anyone knows how?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Create-Random-Negative-and-Positive-Values/m-p/1146502#M908091 alec1982 2020-11-25T16:16:04Z Re: Create Random Negative and Positive Values https://community.qlik.com/t5/QlikView/Create-Random-Negative-and-Positive-Values/m-p/1146503#M908092 <HTML><HEAD></HEAD><BODY><P>Please try the 'rand()' function. Below is an example from Qlik help.</P><P></P><P class="syntax" data-mc-conditions="Targets.NotToTranslate" style="font-size: 12px; margin: 10px 0; font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; color: #0f0f0f; background-color: #f4f4f4;"><SPAN class="script_token" style="font-weight: bold;">rand( )</SPAN></P><P class="example" data-mc-autonum="Example: " style="font-size: 14px; margin: 10px 0; font-weight: bold; color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif;"><SPAN class="autonumber">Example: </SPAN> </P><P style="font-size: 14px; margin: 10px 0; color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif;">This example script creates a table of 1000 records with randomly selected upper case characters, that is, characters in the range 65 to 91 (65+26).</P><P class="code" data-mc-conditions="Targets.NotToTranslate" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; font-size: 12px; color: #0f0f0f;">Load Chr( Floor(rand() * 26) + 65) as UCaseChar, RecNo() as ID Autogenerate 1000;</P></BODY></HTML> Sat, 18 Jun 2016 01:37:41 GMT https://community.qlik.com/t5/QlikView/Create-Random-Negative-and-Positive-Values/m-p/1146503#M908092 Anonymous 2016-06-18T01:37:41Z Re: Create Random Negative and Positive Values https://community.qlik.com/t5/QlikView/Create-Random-Negative-and-Positive-Values/m-p/1146504#M908093 <HTML><HEAD></HEAD><BODY><P>rand()*40-15</P></BODY></HTML> Sat, 18 Jun 2016 03:05:20 GMT https://community.qlik.com/t5/QlikView/Create-Random-Negative-and-Positive-Values/m-p/1146504#M908093 nagaiank 2016-06-18T03:05:20Z Re: Create Random Negative and Positive Values https://community.qlik.com/t5/QlikView/Create-Random-Negative-and-Positive-Values/m-p/1146505#M908094 <HTML><HEAD></HEAD><BODY><P>Hi, use the rand() function</P><P></P><P>Fernando K.</P></BODY></HTML> Sat, 18 Jun 2016 03:26:28 GMT https://community.qlik.com/t5/QlikView/Create-Random-Negative-and-Positive-Values/m-p/1146505#M908094 fkeuroglian 2016-06-18T03:26:28Z