SQL code converted to Qlikview script

Fri, 20 Nov 2020 18:02:30 GMT

Hi there,

I'm new to Qlikview and I have the following query I would like to implement in my app:

select cust_no,

prod_no,

first_name

from

(select cust_no,

prod_no,

first_name,

row_number () over (partition by prod_no, cust_no order by date desc) seq

from customer)

where seq = 1;

How would one go about changing this query to be in Qlikview syntax?

Thank you

Stevie

topic SQL code converted to Qlikview script in QlikView