Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
mariamchang
Contributor
Contributor

Variable incremental que se reinicie

Hola amigos, tengo 

 

fechaclientefactura
01/05/202111
01/06/202112
01/06/202123
01/07/202114
01/07/202135
 nortenorte

 

y me gustaría tener la tabla con el siguiente resultado 

 

fechaclientefacturafactura cliente
01/05/2021111
01/06/2021122
01/06/2021231
01/07/2021143
01/07/2021351
 nortenortenorte

 

No puedo usar Autonumber (RowNo (), porque se tarda demasiado en procesar 

1 Solution

Accepted Solutions
thiago_justen

Hola,

Teste:

Su_Tabla:

Load

fecha,

cliente,

factura,

Num(If(Previous(cliente)=cliente and Previous(factura)<> factura, Peek([cliente factura])+1,1)) as [cliente factura]

From Su_Db Order By cliente,fecha asc;

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago

View solution in original post

1 Reply
thiago_justen

Hola,

Teste:

Su_Tabla:

Load

fecha,

cliente,

factura,

Num(If(Previous(cliente)=cliente and Previous(factura)<> factura, Peek([cliente factura])+1,1)) as [cliente factura]

From Su_Db Order By cliente,fecha asc;

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago

View solution in original post