# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Contributor II

## Generate Random Values

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 ?

Tags (5)
1 Solution

Accepted Solutions
Highlighted
MVP & Luminary

## Re: Generate Random Values

Or

Try like this

Data:

INLINE [

S.No, CustID

1, 101

2, 102

3, 101

4, 105

5, 108

6, 102

];

Temp:

CustID

RESIDENT Data;

LEFT JOIN(Data)

*,

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

RESIDENT Temp;

DROP TABLE Temp;

Regards,

Jagan.

6 Replies
Highlighted
Employee

## Re: Generate Random Values

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

S.No, CustID

1, 101

2, 102

3, 101

4, 105

5, 108

6, 102

];

Highlighted
Contributor II

## Re: Generate Random Values

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.

Highlighted
MVP & Luminary

## Re: Generate Random Values

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.

Highlighted
MVP & Luminary

## Re: Generate Random Values

Or

Try like this

Data:

INLINE [

S.No, CustID

1, 101

2, 102

3, 101

4, 105

5, 108

6, 102

];

Temp:

CustID

RESIDENT Data;

LEFT JOIN(Data)

*,

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

RESIDENT Temp;

DROP TABLE Temp;

Regards,

Jagan.

Highlighted
Employee

## Re: Generate Random Values

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

Highlighted
Contributor II