Min & Max Date

[yadhunandhanan]

Hi Community,

I need to find first,second,third minimum & maximum date of property(Means PropertyID).

Previously I used this below method to find min & max date, but now i need to do this without taking resident. How to do this? Please help me to solve this

MinMaxDate:

Load

Property,

if(previous(Property)=Property and Count(Property) >2  , Min(Date)) as DateMin,

if(previous(Property)=Property and Count(Property) >2 , Min(Date,2)) as DateMax

resident PropData

Group By Property;

join(MinMaxDate)

Load

Property,

if(previous(Property)=Property and Count(Property) >2  , Min(Date,3)) as DateMin,

if(previous(Property)=Property and Count(Property) >2 , Min(Date,4)) as DateMax

resident PropData

Group By Property;

join(MinMaxDate)

Load

Property,

if(previous(Property)=Property and Count(Property) >2  , Min(Date,5)) as DateMin,

if(previous(Property)=Property and Count(Property) >2 , Min(Date,6)) as DateMax

resident PropData

Group By Property;

Thanks

[philipp_kunz]

You could try with the peek() function

Peek ‒ QlikView

Best of luck

[mohamed_ahid]

load your table ordering by date and use peek function as Philipp told you .

[#4]

You can use

peek(DateMin)

peek(DateMax)

[yadhunandhanan]

Thanks Abdulraj

[yadhunandhanan]

Thanks philipp

[yadhunandhanan]

Thanks Mohamed Ahid

[oknotsen]

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .