topic Re: Data rolling 6 years from last reload time in QlikView

Data rolling 6 years from last reload time

canmarroig — Mon, 14 May 2018 10:09:21 GMT

Hi, i've a field Date time formatted as 01/04/2018, in script i've to set 6 years previous data load not from today but from the last data reload that is max(datetime). My calendar should be expressed in as Monthname (04/2018). I'm not able to translate in script, can you help me?

Re: Data rolling 6 years from last reload time

isorinrusu — Mon, 14 May 2018 10:22:45 GMT

Try something like this:

Let vLastReload = Date(floor(ReloadTime()));

Load *

From X

Where yourDate >= Addmonths('$(vLastReload)',-72);

Re: Data rolling 6 years from last reload time

YoussefBelloum — Mon, 14 May 2018 10:34:04 GMT

Hi,

try this:

Max:

Load

Max(D_FINE_VAL) as MaxDate

Resident your_table;

Let vMax = FieldValue('MaxDate',1);

Drop Table Max;

your_table:

LOAD

Date(Date#(Date,'DD/MM/YYYY'),'MM/YYYY') as Date,

FROM...

WHERE Date>addyears($(vMax),-6);

Re: Data rolling 6 years from last reload time

canmarroig — Tue, 15 May 2018 13:06:40 GMT

Tks

Re: Data rolling 6 years from last reload time

YoussefBelloum — Tue, 15 May 2018 13:09:25 GMT

you're welcome good luck