topic Re: Special sequence in straight table? in QlikView

Special sequence in straight table?

olramirez — Tue, 26 Apr 2016 20:58:03 GMT

Hello,

could help me with this special sequence in Straight table please?

The order is by Botiquin, Fecha de Emisión and Documento, but the Sequence should repeat when the Documento column is the same.

Special Sequence	BOTIQUIN	FECHA DE EMISION	DOCUMENTO
1	CUAUHTEMOC METRO FARMA	04/04/2016	ER16-9994
2	CUAUHTEMOC METRO FARMA	13/04/2016	HR16-8404
2	CUAUHTEMOC METRO FARMA	13/04/2016	HR16-8404
2	CUAUHTEMOC METRO FARMA	13/04/2016	HR16-8404
2	CUAUHTEMOC METRO FARMA	13/04/2016	HR16-8404
3	CUAUHTEMOC METRO FARMA	22/04/2016	CR16-9169
4	CUAUHTEMOC METRO FARMA	24/04/2016	CR16-9182
4	CUAUHTEMOC METRO FARMA	24/04/2016	CR16-9182
5	CUAUHTEMOC METRO FARMA	25/04/2016	036600
5	CUAUHTEMOC METRO FARMA	25/04/2016	036600
6	CUAUHTEMOC METRO FARMA	25/04/2016	085133
7	CUAUHTEMOC METRO FARMA	25/04/2016	085139
8	CUAUHTEMOC METRO FARMA	25/04/2016	087533
9	CUAUHTEMOC METRO FARMA	25/04/2016	165969
10	CUAUHTEMOC METRO FARMA	25/04/2016	166000
10	CUAUHTEMOC METRO FARMA	25/04/2016	166000
11	TICOMAN	02/04/2016	207963
12	TICOMAN	13/04/2016	206474
13	TICOMAN	13/04/2016	206477
13	TICOMAN	13/04/2016	206477
14	TICOMAN	25/04/2016	206478
15	TICOMAN	25/04/2016	206487
15	TICOMAN	25/04/2016	206487

Re: Special sequence in straight table?

Anonymous — Tue, 26 Apr 2016 21:35:40 GMT

Hi Olga,

Not sure if I follow the query here. You want a same number to appear in column Special Sequence for the matching values in DOCUMENTO column right? In your screenshot I think that is already the case, no?

Nakul

Re: Special sequence in straight table?

olramirez — Tue, 26 Apr 2016 22:33:26 GMT

Hello Nakul,

yes, That's the case, i would like to know if exist some function to do this sequence.

Thanks

Re: Special sequence in straight table?

olramirez — Tue, 26 Apr 2016 22:39:43 GMT

Hello Sunny,

i don't understand the Autonumber, how can i use it?

Thanks

Re: Special sequence in straight table?

sunny_talwar — Tue, 26 Apr 2016 22:47:56 GMT

Something like this?

Table:

LOAD RowNo() as UniqueKey,

BOTIQUIN,

[FECHA DE EMISION],

DOCUMENTO

FROM

[https://community.qlik.com/thread/214642]

(html, codepage is 1252, embedded labels, table is @1);

FinalTable:

LOAD *,

AutoNumber(BOTIQUIN&[FECHA DE EMISION]&DOCUMENTO) as SpecialSequence

Resident Table

Order By BOTIQUIN, [FECHA DE EMISION], DOCUMENTO;

DROP Table Table;

Re: Special sequence in straight table?

sunny_talwar — Wed, 27 Apr 2016 15:20:18 GMT

Look at the sample I provided below

Re: Special sequence in straight table?

olramirez — Wed, 27 Apr 2016 15:25:15 GMT

Thanks Sunny, i get it!