topic Re: ROW_NUMBER() OVER PARTITION BY in QlikView

ROW_NUMBER() OVER PARTITION BY

harson — Wed, 25 Nov 2020 16:16:04 GMT

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 — Fri, 07 Aug 2020 09:37:12 GMT

Hello,

I attached my solution. I hope this helps.

Maybe there is a better solution?

Kind regards

Peter

harson — Sat, 08 Aug 2020 04:17:26 GMT

Thanks Peter, it worked.

You are the best. 😉