topic Getting Next Occurrence Date in QlikView

Getting Next Occurrence Date

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

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

Re: Getting Next Occurrence Date

sunny_talwar — Wed, 28 Feb 2018 17:44:30 GMT

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;

Re: Getting Next Occurrence Date

Anonymous — Thu, 01 Mar 2018 01:22:38 GMT

Spot on!..

Thanks a bunch

Re: Getting Next Occurrence Date

Brownie — Mon, 31 Oct 2022 10:13:50 GMT

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