Translate a sentence in SQL for Qlik

[alejortizp]

Hi,

I am trying to translate one sentences in SQL for to do in Qlik, this is my sentence:

SELECT *, ROW_NUMBER() OVER(PARTITION BY SalesOrderNumber ORDER BY ProductID) AS NumeroFila FROM Ventas

This is about making a cumulative account that starts at 1 and when you find the next record equal to 2 and so on

[andrey_krylov]

Hi Alejandro. I'm not sure but maybe somthing like this

Load *, AutoNumber(RowNo(), SalesOrderNumber) AS NumeroFila

FROM Ventas

Order By SalesOrderNumber, ProductID;