topic Re: Can anyone figure out why this isn't working? in QlikView

Can anyone figure out why this isn't working?

Tue, 22 Sep 2015 12:28:20 GMT

Hi all,

I have the attached script which I'm using to try and create a temporary calendar table that simply holds dates from my vMinDate to my vMaxDate. For some reason the table isn't loading properly and the only result I get is one entry stating '30/12/1899'!

Can anyone see anything glaringly obvious from the code that I'm missing as I can't seem to figure this one out?!

Any help is appreciated,

Thanks,

Samuel

Re: Can anyone figure out why this isn't working?

alexandros17 — Tue, 22 Sep 2015 12:31:58 GMT

Dates format is unrecognized, try with

'2020/12/31' and '2015/01/01'

Re: Can anyone figure out why this isn't working?

Tue, 22 Sep 2015 12:45:39 GMT

Unfortunately this isn't correcting the issue, I'm rather stumped by this!

Re: Can anyone figure out why this isn't working?

Anonymous — Tue, 22 Sep 2015 12:48:09 GMT

what is your dateformat? can you create a texstobject with (date(today()).

Use this Format for your calendar

Re: Can anyone figure out why this isn't working?

Ralf-Narfeldt — Tue, 22 Sep 2015 12:49:10 GMT

You have some data format variables at the beginning of the script, does it say this or something else?

SET DateFormat='MM/DD/YYYY';

Re: Can anyone figure out why this isn't working?

tresB — Tue, 22 Sep 2015 12:50:05 GMT

Redefine your variables like:

let vMaxDate= Num(MakeDate(2020, 12, 31));

let vMinDate= Num(MakeDate(2015, 1, 1));

To explain why that is not working:

'31/12/2020' - is actually being expanded (because of $) and generating a number

31 divided by 12 divided by 2020 ->0.0012... // '/' is being considered as numeric operator

And if you apply date(0.0012)- you get the first that of qv calendar system : '30/12/1899'

Re: Can anyone figure out why this isn't working?

simenkg — Tue, 22 Sep 2015 12:50:16 GMT

the variables needs to be numbers, not strings.

let vMaxDate = Floor(Date#('31/12/2020','DD/MM/YYYY'))

let vMinDate = Floor(Date#('01/01/2015','DD/MM/YYYY'));

or just use

let vMaxDate = Floor(MakeDate(2020,12,31));

let vMinDate = Floor(MakeDate(2015,01,01));

Re: Can anyone figure out why this isn't working?

sunny_talwar — Tue, 22 Sep 2015 12:51:24 GMT

Try this may be:

LET vMaxDate = Date#('31/12/2020', 'DD/MM/YYYY')

LET vMINDate = Date#('01/01/2015', 'DD/MM/YYYY')

Re: Can anyone figure out why this isn't working?

Tue, 22 Sep 2015 12:56:06 GMT

Just like to take the opportunity to thank everyone who's contributed, I can only mark a few questions though so please don't get offended if it isn't yours.