topic Re: Random numbers without repeating in QlikView

Random numbers without repeating

Anonymous — Wed, 25 Jul 2018 21:42:10 GMT

Hi, guys. I hope you can help me

I need exactly to assign a number to the value of the field Team Name between 1 and 8, but not repeat a already number assigned

Teams:

LOAD * INLINE [

TeamName

Mexico

Brazil

Colombia

France

USA

Argentina

Peru

Spain];

Example Result:

Thank's

Re: Random numbers without repeating

BalaBhaskar_Qlik — Thu, 26 Jul 2018 09:02:22 GMT

May be:

In Expressions: Rank(Only(TeamName),7) - Label - Rank

In Script:

Teams:

LOAD * INLINE [

TeamName

Mexico

Brazil

Colombia

France

USA

Argentina

Peru

Spain];

FinalTable:

LOAD *,

If(TeamName <> Previous('TeamName'), RangeSum(Peek('Rank'), 1), 1) as Rank

Resident Table

Order By TeamName desc;

DROP Table Teams;

Re: Random numbers without repeating

ogautier62 — Thu, 26 Jul 2018 09:07:01 GMT

take a look at function Autonumber() it's made for this :

Autonumber(TeamName)

regards

Re: Random numbers without repeating

tresB — Thu, 26 Jul 2018 09:15:07 GMT

Only thing is, it would not be random, but sequential.

Re: Random numbers without repeating

ogautier62 — Thu, 26 Jul 2018 09:29:34 GMT

you are right,

so :

LOAD *, rand() as rand FROM 'your table'

load *, autonumber(rand) as nb resident 'your table' order by rand;

that changes on each load

Re: Random numbers without repeating

petter — Thu, 26 Jul 2018 10:19:39 GMT

This is a way to get a randomly picked list of teams: