Generate random numbers in a field

[rido1421]

Hi There

I would like to create a field with random numbers within a table ranging from 1- 10

I know the Autonum funtion doesnt work like this, im using it to display what i require...

Load

Transactions:

[Sales Value],

[Sales Quantity],

[Agent Name],

Autonum(10) as [Client Code]

Regards,

[rido1421]

HI Marco

qlikview 11...

[MarcoWedel]

And it delivers 1 to 10 using this expression?

regards

Marco