topic Re: Generate Random Values in QlikView

Generate Random Values

sibideepak — Wed, 08 Apr 2015 05:40:10 GMT

Hi all ,

I want to generate some random values between 20 to 50 for each ID in my table.

Example:

S.No CustID Value

1 101 22

2 102 36

3 101 22

4 105 29

5 108 45

6 102 36

If is it possible .. how to do it ?

Thanks in advance

Re: Generate Random Values

Ralf-Narfeldt — Wed, 08 Apr 2015 05:47:06 GMT

LOAD *,

Floor(Rand()*30) + 20 As Value;

LOAD * INLINE [

S.No, CustID

1, 101

2, 102

3, 101

4, 105

5, 108

6, 102

];

Re: Generate Random Values

sibideepak — Wed, 08 Apr 2015 06:13:02 GMT

Thanks Ralf,

But again have a look at description and example where each CustID have same value all time ..dont change every time ..i.e) for 101 value should always be 22 and for 102 it is 36.

Re: Generate Random Values

jagan — Wed, 08 Apr 2015 06:30:37 GMT

Hi,

Try like this

Data:

LOAD *, AutoNumber(CustID) + 20 As Value

INLINE [

S.No, CustID

1, 101

2, 102

3, 101

4, 105

5, 108

6, 102

];

Hope this helps you.

Regards,

Jagan.

Re: Generate Random Values

jagan — Wed, 08 Apr 2015 06:34:14 GMT

Try like this

Data:

LOAD *

INLINE [

S.No, CustID

1, 101

2, 102

3, 101

4, 105

5, 108

6, 102

];

Temp:

LOAD Distinct

CustID

RESIDENT Data;

LEFT JOIN(Data)

LOAD

Floor(Rand() * 30 + 20) AS Value

RESIDENT Temp;

DROP TABLE Temp;

Regards,

Jagan.

Re: Generate Random Values

Ralf-Narfeldt — Wed, 08 Apr 2015 06:55:20 GMT

Sorry, missed that point with the CustID. Then you need to load a distinct CustID table and join like Jagan's second example.

Re: Generate Random Values

sibideepak — Wed, 08 Apr 2015 08:57:05 GMT

Thanks for your answer !! Hope it'll work for my scenario