topic Numbers instead of dates in QlikView

Numbers instead of dates

Anonymous — Wed, 23 Oct 2013 15:36:16 GMT

Hi,

I have a file, where I have calendars.

I'd like to see real dates instead of numbers in current selection.

Please find my attached file.

Regards,

Re: Numbers instead of dates

salto — Wed, 23 Oct 2013 15:43:33 GMT

Hi Vladimir,

maybe you should change the date format of the field in the script:

LOAD submitDateTime,

...

date(floor(submitDateTime,'MM/DD/YYYY')) as oDate

...

Hope this helps

Re: Numbers instead of dates

Anonymous — Wed, 23 Oct 2013 15:45:45 GMT

I changed, in this case calendar doesn't work

Re: Numbers instead of dates

yduval75 — Wed, 23 Oct 2013 15:46:19 GMT

Hello,

Use the date function in the script editor.

Date(floor(submitDateTime), 'M/D/YYYY') as oDate

Regards

Yoann

Re: Numbers instead of dates

Anonymous — Wed, 23 Oct 2013 15:47:30 GMT

in this case calendar doesn't work

Re: Numbers instead of dates

Anonymous — Wed, 23 Oct 2013 15:58:00 GMT

Hi,

Some how I could not open your file, I guess u have time stamp for your date column just use Floor() as oDate which will truncate timestamp if it not once check your max and min dates from your calender if they are throwing float values or any other values than expected,try using Date(Date#(min(oDate))) for min and max values... Hope it Works...

Re: Re: Numbers instead of dates

salto — Wed, 23 Oct 2013 16:00:36 GMT

Hi,

the syntax of the trigger in variables vStart and vEnd need to be changed to:

='>=' &date(vStart,'MM/DD/YYYY') & '<=' &date(vEnd,'MM/DD/YYYY')

Now the calendar works. PFA.

Hope this helps.

Re: Numbers instead of dates

preminqlik — Wed, 23 Oct 2013 16:03:59 GMT

TRY THIS :

LOAD submitDateTime,

DATE(Timestamp#(submitDateTime)) AS date,

[qID_15863_Purpose of Visit],

[qID_15879_Next step],

MonthName(Monthstart(date(submitDateTime))) as MYear,

floor(submitDateTime) as oDate

FROM

C:\Users\Desktop\Book1.xlsx

(ooxml, embedded labels);

Re: Re: Numbers instead of dates

Anonymous — Wed, 23 Oct 2013 16:09:47 GMT

Thank you

Re: Numbers instead of dates

salto — Wed, 23 Oct 2013 19:49:19 GMT

Hi.

Don't forget to mark the answer as correct... It may help other users.

Regards.

El 23/10/2013, a las 18:10, Vladimir Kostochka <qcwebmaster@qlik.com> escribió:
QlikCommunity
Re: Numbers instead of dates
reply from Vladimir Kostochka in New to QlikView - View the full discussion
Thank you
Reply to this message by replying to this email, or go to the message on QlikCommunity
Start a new discussion in New to QlikView by email or at QlikCommunity
Following Re: Numbers instead of dates in these streams: Inbox
© 1993-2013 QlikTech International AB Copyright & Trademarks | Privacy | Terms of Use | Software EULA

Re: Numbers instead of dates

Anonymous — Wed, 23 Oct 2013 20:55:14 GMT

Thanks for your help.

I marked right away.

Re: Numbers instead of dates

Wed, 23 Oct 2013 21:00:34 GMT

Go to the Menu Settings->Document properties. In the Number tab, select the field oDate, and change the format to Date. Click apply. Clear the selection. It will apply the date format in the selection box, when new values are selected.