topic Re: Where Date in QlikView

Where Date

bobbydave — Fri, 20 Nov 2020 18:02:30 GMT

I am writing a Where statement to say

Load Audit.Date

from ..... (qvd)

where Date#(Audit.Date, 'DD/MM/YYYY') >= MakeDate(2013,12,28)

but Audit.Date is a text number as in 41266

How would I write the where statement to accommodate the Audit.Date is greater than 28/12/2013?

Thanks

Re: Where Date

Wed, 30 Sep 2015 15:08:09 GMT

Hi Qlikview internally converts Date into number while storing into qvd.

LET vMinDate = Num(MakeDate(2013,12,28));

Load

From qvd_name.qvd (qvd)

where

Audit.Date >= $(vMinDate)

;

or Audit.Date >= Num(MakeDate(2013,12,28))

Re: Where Date

Digvijay_Singh — Wed, 30 Sep 2015 15:10:44 GMT

see if this works -

Load Audit.Date

from ..... (qvd)

where Date(Num(Audit.Date),'DD/MM/YYYY')>= Date(MakeDate(2013,12,28),'DD/MM/YYYY')

Re: Where Date

avinashelite — Wed, 30 Sep 2015 15:10:48 GMT

try like this :

where Date(Date#(Audit.Date), 'DD/MM/YYYY') >= MakeDate(2013,12,28)

Re: Where Date

Wed, 30 Sep 2015 15:12:25 GMT

Try:

Where Date(Audit.Date,'DD/MM/YYYY')>='28/12/2013'

Re: Where Date

sunny_talwar — Wed, 30 Sep 2015 20:37:43 GMT

May be this:

Load Audit.Date

FROM ..... (qvd)

Where Num#(Audit.Date, '##') >= Num(MakeDate(2013,12,28));

Re: Where Date

maxgro — Wed, 30 Sep 2015 21:09:46 GMT

if Audit.Date is date or a num (you said as in 41266)

....

where

Audit.Date >= MakeDate(2013,12,28)

Re: Where Date

MarcoWedel — Wed, 30 Sep 2015 22:32:38 GMT

Hi,

one solution could be:

LOAD Date(Audit.Date) as Audit.Date
Inline [
Audit.Date
41266
41267
41268
41269
41270
41271
41272
41273
41274
41275
41276
41277
41278
41279
]
Where Audit.Date >= Date#('28/12/2012','DD/MM/YYYY');

(replacing the inline load with your qvd)

And check if there are dates at all after 28/12/2013 in your qvd.

41266 for example represents 12/23/2012 not 2013.

hope this helps

regards

Marco

Re: Where Date

MarcoWedel — Wed, 30 Sep 2015 22:34:33 GMT

depending on your DateFormat definition even

Where Audit.Date >= '28/12/2012';

should work.

regards

Marco