Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
knightwriter
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
sunny_talwar

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
sunny_talwar

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

knightwriter
Creator III
Creator III
Author

nice one - worked a charm