Discussion Board for collaboration related to QlikView App Development.
I'm dealing with a apparently easy problem to solve but i've tried so many times that i can't think of nothing anymore. So here's the deal.
(nervermind the zeros, but that's my problem).
See that BOB has 2 jobs, but one got 2 registers. I want to generate a sequence that adds(+1) to the new job for the person. Repeating till the next job row updates. It would be like this:
I know it's simple but i can't figure it out. Thanks in advance! 😃
load *, rowno() as id inline [
Person, Job, Sequence
Bob, Exec10, 0
Chris, DevII, 0
Terry, Aux ,0
Tiffany ,Dev, 0
id, Person, Job,
peek(Sequence))) as Sequence
order by Person, Job;
DROP Table a;
View solution in original post
Thanks, man! While i was waiting for a response, i've tried this
if(previous(Person)<>Person,1, if(previous(Person)=Person and previous(Job)<>Job,numsum(Peek('Sequencia'),1),Peek('Sequencia'))) as Sequencia
But it didn't seem to work... after some search there was some trash in our data, f***ing the sequence.
Both yours and mine solution works now. Thanks for your attention!
It's always good to know that are more than one solution 😃