Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Straight Table with record counter that resets

Hello,

I have a requirement in which the user wants to assign records in a straight table to variable number of individuals assigned by number. For instance, the user wants to assign the records among 5 individuals. This would need to be variable on the front-end where I would have a slider object allowing the user to define the number of individuals. In this example they have selected 5. Can you reset the rowno(total) counter?

ItemAssigned Group

1

1
22
33
44
55
61
72
83
94
105
111
122
2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Straight Table with record counter that resets

Mod(RowNo(Total)-1,$(vDivider))+1


talk is cheap, supply exceeds demand
Highlighted
Contributor
Contributor

Re: Straight Table with record counter that resets

=MOD(RowNo(Total)-1,$(Var3))+1

Thanks Gysbert!