Discussion Board for collaboration related to QlikView App Development.
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
LOAD * INLINE [
In Expressions: Rank(Only(TeamName),7) - Label - Rank
If(TeamName <> Previous('TeamName'), RangeSum(Peek('Rank'), 1), 1) as Rank
Order By TeamName desc;
DROP Table Teams;
take a look at function Autonumber() it's made for this :
Only thing is, it would not be random, but sequential.
you are right,
LOAD *, rand() as rand FROM 'your table'
load *, autonumber(rand) as nb resident 'your table' order by rand;
that changes on each load
This is a way to get a randomly picked list of teams: