Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Allocating numbers 1-10 to rows in table

Hello,

I have a (suposedly) very simple problem, however, I have been sitting for hours to figure this out and haven't found any help in prior topics.

I have a table with ~200-300k rows that is concatenated and joined from many other tables. And in this loaded table I need to assign numbers 1-10 to each row (each number represents an owner), they should probably be assigned in a continous form (1....3....10...1......4...5...etc), so that each owner gets equal number of rows.

Example

Client,     Product,     Owner

John,     xxxx,     1

Mark,     yyyy,     2

Kate,     zzzz,     3

.....

Elviss,     oooo,     10

Chuck,     pppp,     1

etc.

Please help It should be done in the table, because, the output data needs to be equally asigned to owners even if filters are changed.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Are you looking for something like

=mod(rowno(TOTAL)-1,10)+1

?

View solution in original post

2 Replies
swuehl
MVP
MVP

Are you looking for something like

=mod(rowno(TOTAL)-1,10)+1

?

Not applicable
Author

I new it should be simple, too bad I didn't know this function.

Thanks' a lot!!