ROW_NUMBER() OVER PARTITION BY

[harson]

Can someone help me to have this query in QlikView.

In T-SQL :

SELECT ROW_NUMBER() OVER(PARTITION BY ID ORDER BY ActionTime) as Attempt,
ID,
ActionTime

FROM [dbo].[TestTable]

The idea is to have an attempt number for each ID, ordered automatically according to the ActionTime column.

Thanks already for your precious help

[peterwh · Accepted solution]

Hello,

I attached my solution. I hope this helps.

Maybe there is a better solution?

Kind regards

Peter

[harson]

Thanks Peter, it worked.

You are the best. 😉