Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
alejortizp
Contributor III
Contributor III

Translate a sentence in SQL for Qlik

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

Labels (1)
1 Reply
andrey_krylov
Specialist
Specialist

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

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

FROM Ventas

Order By SalesOrderNumber, ProductID;