Getting Next Occurrence Date

[Anonymous]

Hi All,

I am quite new with qlikview, and I am currently struggling to find the solution for my case.

I have only this table.

And I would like to have extra column in the table like below. Basically that column is looking for the next occurrence DATE for particular NAME, otherwise keep it with today's date

Any suggestion on how to make it happen on script load level?

Your ideas are much appreciated

[sunny_talwar · Accepted solution]

Try this

Table:

LOAD * INLINE [

    DATE, NAME, LOCATION

    01/05/2017, BD1, A

    01/09/2017, BD2, M

    02/10/2017, BD1, G

    03/15/2017, BD1, X

    04/01/2017, BD1, TRASH

    04/10/2017, BD2, TRASH

];

FinatTable:

LOAD *,

Date(If(NAME = Previous(NAME), Previous(DATE), Today())) as [Next Date]

Resident Table

Order By NAME, DATE desc;

DROP Table Table;

[Anonymous]

Spot on!..

Thanks a bunch

[Brownie]

I cant get my this desired result using your method.  I need this particular arrangement.