Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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