Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
harson
Contributor III
Contributor III

ROW_NUMBER() OVER PARTITION BY

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]

 

harson_0-1596785425945.png

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

Thanks already for your precious help

 

1 Solution

Accepted Solutions
peterwh
Creator II
Creator II

Hello,

I attached my solution. I hope this helps.

Maybe there is a better solution?

 

Kind regards

Peter

View solution in original post

2 Replies
peterwh
Creator II
Creator II

Hello,

I attached my solution. I hope this helps.

Maybe there is a better solution?

 

Kind regards

Peter

harson
Contributor III
Contributor III
Author

Thanks Peter, it worked.

You are the best. 😉