topic Re: Next field Value in QlikView

Next field Value

qlikviewuser20 — Thu, 05 May 2016 11:41:51 GMT

Hi,

I have a table structured like this:

i want to add a new column with end_date_of Debit to store the next field in Date_Crédit column like that:

Any idea how can i do that in the script so i can calculate duration of debit ?

Thank you so much

sunny_talwar — Thu, 05 May 2016 15:09:52 GMT

May be this:

Table:

LOAD RowNo() as Sort,

LOAD * Inline [

Date_Débit, Date_Crédit

01/02/2013,

,01/04/2013

,12/04/2013

,01/05/2013

10/06/2014,

,12/08/2014

];

FinalTable:

LOAD *,

If(Len(Trim(Date_Crédit)) = 0, Peek('Date_Crédit')) as Date_Fin_Débit

Resident Table

Order By Sort desc;

DROP Table Table;

sunny_talwar — Thu, 05 May 2016 15:53:17 GMT

Try this:

Table:

LOAD RowNo() as Sort,

LOAD * Inline [

Date_DEBIT, date_CREDIT

01/01/2013,

01/03/2013,

, 01/04/2013

];

FinalTable:

LOAD *,

If(Len(Trim(date_CREDIT)) = 0, Alt(Peek('date_fin_debit'), Peek('date_CREDIT'))) as date_fin_debit

Resident Table

Order By Sort desc;

DROP Table Table;