Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER 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
Creator

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
Creator

Hello,

I attached my solution. I hope this helps.

Maybe there is a better solution?

 

Kind regards

Peter

View solution in original post

harson
Contributor III
Contributor III
Author

Thanks Peter, it worked.

You are the best. 😉