Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Table with duplicate rows

Good afternoon, dear, how are you?

In my QlikView table, the data is appearing duplicity, would you have any way to bring just the line that has the latest date?

Here's an example image of how my table is

Thanks hugs

 

Labels (1)
2 Solutions

Accepted Solutions
Highlighted
Partner
Partner

Whats a reliable identifier for that table?
what you need to do is after load your table.
resident load another one and do an inner join
e.g.
inner join (YourTable)
load
ID,
Max(Date) as Date
resident YourTable

View solution in original post

Highlighted
Specialist III
Specialist III

Use Firtsortedvalue() or Max() function to find the latest Dt.

View solution in original post

2 Replies
Highlighted
Partner
Partner

Whats a reliable identifier for that table?
what you need to do is after load your table.
resident load another one and do an inner join
e.g.
inner join (YourTable)
load
ID,
Max(Date) as Date
resident YourTable

View solution in original post

Highlighted
Specialist III
Specialist III

Use Firtsortedvalue() or Max() function to find the latest Dt.

View solution in original post