topic Create Random Column with 15 to 25 % in QlikView

Create Random Column with 15 to 25 %

alec1982 — Wed, 25 Nov 2020 16:16:04 GMT

Need to create a column from a sales amount column to show randomly 15 to 25% for a sales column. Anyone has a quick logic

sunny_talwar — Thu, 16 Jun 2016 18:06:47 GMT

May be like this:

((Rand() * (0.25 - 0.15)) + 0.25) * Sales as Rand_Sales

Clever_Anjos — Thu, 16 Jun 2016 18:07:36 GMT

Maybe this?

Transactions:

Load

Rand1

Where Rand1 >= 0.15 and Rand1 <= 0.25;

Load

Rand() as Rand1

Autogenerate 100000;

alec1982 — Thu, 16 Jun 2016 18:55:20 GMT

this returns more than 25% of the sales amount.

Thanks,

Badr

alec1982 — Thu, 16 Jun 2016 18:56:45 GMT

my table has two columns

Transaction ID and Sales Amount

I need to add additional column for profit and it is random values of 15 to 25 % of sales amount

sunny_talwar — Thu, 16 Jun 2016 18:57:54 GMT

My bad, it should have been this:

((Rand() * (0.25 - 0.15)) + 0.15) * Sales as Rand_Sales

Clever_Anjos — Thu, 16 Jun 2016 19:00:44 GMT

Transactions:

Load

[Transaction ID]

, Rand1 as [Sales Amount]

Where Rand1 >= 0.15 and Rand1 <= 0.25;

Load

Rand() as Rand1,

recno() as [Transaction ID]

Autogenerate 100000;