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