Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Max Date / duplicate query

Hi All,

I have two fields, [Opportunity ID] and [updated Date]. As there can be multiple changes associated on one ID, I want to only pull the lastest Date listed with that ID.

If not, the same ID will be listed multiple times with a value amount that will be double counted. 

Im doing this in a straight table with chart properties and so can be done within the Dimensions or Expressions.

Could it be something like? All help much appreciated

=Max(Date(if( [Opportunity.ID] [Opportunity.ID],  [updated Date]))

1 Solution

Accepted Solutions
Highlighted

Re: Max Date / duplicate query

May be this as calculated dimension

Aggr(If([updated Date] = Max(TOTAL <[Opportunity.ID]> [updated Date]), [Opportunity.ID]), [Opportunity.ID], [updated Date])

View solution in original post

2 Replies
Highlighted

Re: Max Date / duplicate query

May be this as calculated dimension

Aggr(If([updated Date] = Max(TOTAL <[Opportunity.ID]> [updated Date]), [Opportunity.ID]), [Opportunity.ID], [updated Date])

View solution in original post

Highlighted
Creator III
Creator III

Re: Max Date / duplicate query

nice one - worked a charm