topic Re: load data till previous two week in QlikView

load data till previous two week

New-Qlik — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I want to load data from database for last week

Table

select

Date, ---------is in yyyy:mm:dd hh:mm format

Sales,Name

from ABC;

I tried

1.select Date, Sales,Name from ABC

where Date >= max(Date) -14

its not wokring

2. Let vmaxdate= max(date)

load

Date,Sales, NAme

resident table

where Date >= $(vmaxdate) -14

. Let vmaxdate= peek(date)

load

Date,Sales, NAme

resident table

where Date >= $(vmaxdate) -14

Please suggest where I am going wrong

Re: load data till previous two week

sunny_talwar — Thu, 11 Aug 2016 11:06:24 GMT

Have you made sure that your date is read correctly by QlikView?

Get the Dates Right

Why don’t my dates work?

Re: load data till previous two week

New-Qlik — Thu, 11 Aug 2016 12:04:26 GMT

I have used Date(Floor(Date )) function to convert it

Re: load data till previous two week

puttemans — Thu, 11 Aug 2016 12:16:20 GMT

You could try

WHERE Date > Num(Today()-8)

Re: load data till previous two week

Thu, 11 Aug 2016 12:20:59 GMT

and you added a line like

TRACE $(vmaxdate) -14

To see what the end value is... I am not sure - 14 is the way forward... generally this is done where the date is represented as a number and not an actual day.

Re: load data till previous two week

New-Qlik — Thu, 11 Aug 2016 17:17:05 GMT

Thanks but I ant use today()

have to do max(date) i.e. last date -14

Re: load data till previous two week

Wed, 31 Aug 2016 09:52:19 GMT

did you have any luck?

Re: load data till previous two week

New-Qlik — Wed, 31 Aug 2016 10:07:17 GMT

No not yet

Re: load data till previous two week

Wed, 31 Aug 2016 10:09:42 GMT

Did you add Trace into the loading of the data so that you could see what the value was which was being used?

That will appear on the reload screen