topic Re: id Generator in QlikView

id Generator

Anonymous — Tue, 20 Oct 2015 19:09:36 GMT

good afternoon I need your help ... I want to create QlikView id for each change me the name of a program I get a different id ... annex an example of what I want to do qlikview ...

1 power rangers
2 Today
2 Today
2 Today
3 SpongeBob
4 Sylvester & Tweety Mysteries
5 today
5 today

what I need is that each change the program assigned me a new id

Re: id Generator

sunny_talwar — Tue, 20 Oct 2015 21:13:13 GMT

Try this:

LOAD Program,

If(Peek('Program') = Program, Peek('ID'), Peek('ID') + 1) as ID

FROM Source

LOAD Program,

Alt(If(Peek('Program') = Program, Peek('ID'), Peek('ID') + 1), 1) as ID

FROM Source

Re: id Generator

sunny_talwar — Tue, 20 Oct 2015 21:19:50 GMT

Attaching a sample. Script:

Table:

LOAD * Inline [

Program

power rangers

Today

SpongeBob

Sylvester & Tweety Mysteries

today

];

NewTable:

LOAD RowNo() as [Row Number],

Program,

Alt(If(Peek('Program') = Program, Peek('ID'), Peek('ID') + 1), 1) as ID

Resident Table;

Output

Row Number is added just to show that you have Today showing up thrice, otherwise table box would have just showed it once.

HTH

Best,

Sunny

Re: id Generator

hic — Tue, 20 Oct 2015 21:20:31 GMT

sunindia

Almost right. However, Peek('ID') will return NULL on the first row and since NULL + 1 => NULL, it will not work.

Try this instead:

LOAD Program,

If(Peek('Program') = Program, Peek('ID'), RangeSum(Peek('ID'), 1)) as ID

FROM Source

HIC

Re: id Generator

sunny_talwar — Tue, 20 Oct 2015 21:22:23 GMT

I did find my mistake, but handled it a little differently with Alt function. But I do like RangeSum solution, much more elegant. Thanks for sharing

Alt(If(Peek('Program') = Program, Peek('ID'), Peek('ID') + 1), 1) as ID

Re: id Generator

Anonymous — Tue, 20 Oct 2015 21:34:22 GMT

thank you very much was very useful help your greetings

luis espinoza

Re: id Generator

Anonymous — Tue, 20 Oct 2015 21:36:13 GMT

thank you