Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SQL code converted to Qlikview script

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

0 Replies