Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
vijaymadhavan28
Contributor
Contributor

AutoNumber slow down performance

Hi All,

I am trying to implement the below SQL script in QlikView to get the latest sequence number and facing performance issue while implementing "AutoNumber"  as an equivalent for rank(). Table contains around 1 Million record.

SQL Script:

select id, response_id, seq_num, create_dt, sent_date,
rank() over(partition by id order by sent_date,response_id) as seq_num
from table_name where seq_num=1;

 

QlikView Script:

Load
id, response_id, seq_num, create_dt, sent_date,
AutoNumber (RowNo(),id ) as new_seq
from
table_name.qvd(qvd)
where seq_num=1;

Could you please advise on how to overcome the performance issue?

Thanks in advance.

 

Labels (2)
1 Solution

Accepted Solutions
1 Reply
MarcoWedel