topic Re: Log reader in QlikView

Log reader

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

i have this logreader that I downlaoded from the resource library. how can I make it so that it only loads last weeks data instead of reading everything in the logfile driectory?

cheers

Re: Log reader

richard_chilvers — Mon, 09 May 2016 13:10:31 GMT

I'm sure you could dabble in the script, but I seem to think there are selection criteria in the front-end to filter the period you look at ?

Re: Log reader

Mon, 09 May 2016 13:13:57 GMT

Yes sure theres a period to filter on. But I'm not interested in logfiles from wayback and also it just consumes time to load them all. Therefor I was wondering if you could set a where statement in scipt to only get the last weeks logfiles or so,,,

Re: Log reader

avinashelite — Mon, 09 May 2016 13:16:58 GMT

Try like this

LET vMaxDate: '=max(date_created)';

LET vFirstOfLast7: '=max(date_created,6)';

LOAD *

from table_name

where date>vFirstOfLast7;

Re: Log reader

Mon, 09 May 2016 13:25:42 GMT

Could you specify more? My Datecolumn is called "Date"

Re: Log reader

Anonymous — Mon, 09 May 2016 14:45:25 GMT

Could this work?

LET FromDate = Today()-7;

LET ToDate = Today()-1;

Directory;

LOAD Date,

Num

FROM

TableIndata.txt

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

WHERE Date >= $(FromDate) AND Date <= $(ToDate);

You can manipulate FromDate and ToDate as you like, in this case today's entries would not be included (which may not be what you want but I just wanted to include both conditions).

Re: Log reader

avinashelite — Tue, 10 May 2016 05:49:32 GMT

could you please share the sample data ..so that it will helpful to give the correct solution