topic Re: Max Date / duplicate query in QlikView

Max Date / duplicate query

knightwriter — Wed, 25 Nov 2020 16:16:04 GMT

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]))

Re: Max Date / duplicate query

sunny_talwar — Thu, 04 Jan 2018 14:46:16 GMT

May be this as calculated dimension

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

Re: Max Date / duplicate query

knightwriter — Thu, 04 Jan 2018 16:36:55 GMT

nice one - worked a charm