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

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

How to Join to first row qlikview

I have the follwoing script

sales :

Load *

from test.qvd ;

LEFT  JOIN(sales )

IntervalMatch (datecol)

LOAD DISTINCT [DATE DEBUT]

      ,[DATE FIN]

resident      OC

      ;

      LEFT JOIN (sales )

LOAD *

RESIDENT OC;

I got duplicates rows . so how to Join to first row in qlikview ?

1 Reply
MK_QSL
MVP
MVP

Add one more line

Drop Table OC;