topic Re: Create a master calendar from a non-date format? in QlikView

Create a master calendar from a non-date format?

Anonymous — Fri, 15 Jul 2016 12:37:08 GMT

Hello!

I have two tables, one for dates and onte for times that are not recognized by Qlik as date formats (currently presented as YYYYMMDD and hh:mm:ss, respectively). How can I separate these two tables into separate year, month, day, and time tables to continue to build a master calendar for my app?

Thanks in advance!

/Charlotte

Re: Create a master calendar from a non-date format?

makrishnaraj — Fri, 15 Jul 2016 13:36:38 GMT

Hi,

Hope this will help you.

How to create a Calendar

Re: Create a master calendar from a non-date format?

sunny_talwar — Fri, 15 Jul 2016 13:38:47 GMT

Check this link out:

The Master Time Table

Re: Create a master calendar from a non-date format?

rwunderlich — Fri, 15 Jul 2016 19:49:06 GMT

I'd suggest the first step is to make the dates proper dates when loading.

date(date#(thedate, 'YYYYMMDD')) as thedate

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Create a master calendar from a non-date format?

Anonymous — Mon, 18 Jul 2016 06:41:25 GMT

Hi Rob, thanks for the help. I'm not sure how to do this properly though. Let's call my datefield XX, how should I write my script to make it proper?

If I understand your post correctly it should be: date(date#(XX, 'YYYYMMDD')) as XX, but that doesn't seem to work.

Re: Create a master calendar from a non-date format?

rwunderlich — Mon, 18 Jul 2016 15:40:29 GMT

date(date#(XX, 'YYYYMMDD'))

should work if your input dates are in the YYYYMMDD format. I wasn't clear from your first post if YYYYMMDD was the input format as well.

Where are your dates loaded from, file or database? What is the format?

-Rob

Re: Create a master calendar from a non-date format?

Anonymous — Wed, 20 Jul 2016 06:24:16 GMT

Thank you! I managed to get it to work by changing my datefield xx, to XX

Re: Create a master calendar from a non-date format?

oknotsen — Wed, 20 Jul 2016 07:54:54 GMT

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .