topic Re: Load yesterday data in QlikView

Load yesterday data

Anonymous — Wed, 10 Jul 2013 15:04:56 GMT

Hi guys,

I want to load only yesterday data from SQL.

I create variable

Let vToday = date(Today()-1);

Load date(floor(submitDateTime)) as oDate,*;

FROM.dbo.Data

WHERE submitDateTime='$(vToday)';

I load exactly time 2013-07-09 00:00:00.

Who can help me round my condition?

I know I can use condition add new variable today and use

WHERE submitDateTime>='$(vToday1) and submitDateTime<='$(vToday)';

Thanks,

Re: Load yesterday data

ariel_klien — Wed, 10 Jul 2013 15:10:04 GMT

Try

Let vToday = DATE#(Today()-1);

...

WHERE DATE#(submitDateTime)='$(vToday)';

Ariel

Re: Load yesterday data

Anonymous — Wed, 10 Jul 2013 15:12:53 GMT

Thanks for reply.

It didn't work, because vToday is number format. submitdatetime is 2013-07-09 00:00:00

Thanks,

Re: Load yesterday data

ariel_klien — Wed, 10 Jul 2013 15:16:22 GMT

Try

Let vToday = DATE#(Today()-1,'YYYY-MM-DD');

...

WHERE DATE#(submitDateTime,'YYYY-MM-DD')='$(vToday)';

Ariel

Re: Load yesterday data

Anonymous — Wed, 10 Jul 2013 15:20:11 GMT

QV date# is not recognized built-in function name.

Re: Load yesterday data

ariel_klien — Wed, 10 Jul 2013 15:23:04 GMT

Try to Lose the #

use only Date(submitDateTime,'YYYY-MM-DD')

Re: Load yesterday data

Anonymous — Wed, 10 Jul 2013 15:25:41 GMT

the same.

didn't work

Re: Load yesterday data

Anonymous — Wed, 10 Jul 2013 15:45:33 GMT

Maybe somebody knows better way than that

Let vToday1 = date(Today()-1);

Let vToday = date(Today());

FROM Data

WHERE submitDateTime>='$(vToday1)' and submitDateTime<'$(vToday)';

Thanks,