Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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