topic Re: Put values in previous lines in QlikView

Put values in previous lines

ecabanas — Fri, 08 Jul 2016 10:57:44 GMT

I have this table without the To field in null.

I want to close the lines where there is a new one and if there is no new, T0= Today()

Many thank's

Eduard

sunny_talwar — Fri, 08 Jul 2016 11:24:19 GMT

Try this:

Table:

LOAD * INLINE [

ItemId, Rate_Id, Rate, From

10362678, 10362678-42370, 2.99, 01/01/2016,

10362678, 10362678-42415, 3.08, 15/02/2016,

10362678, 10362678-42416, 3.08, 16/02/2016,

10356767, 10356767-42370, 6.82, 01/01/2016,

10356767, 10356767-42395, 6.32, 26/01/2016

];

FinalTable:

LOAD *,

Date(If(ItemId = Previous(ItemId), Previous(From), Today())) as To

Resident Table

Order By ItemId, From desc;

DROP Table Table;

ecabanas — Fri, 08 Jul 2016 11:35:58 GMT

Your aree sooooooo big

sunny_talwar — Fri, 08 Jul 2016 12:12:10 GMT

Why am I so big my friend