Create a master calendar from a non-date format?

[Anonymous]

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

[makrishnaraj]

Hi,

Hope this will help you.

How to create a Calendar

[sunny_talwar]

Check this link out:

The Master Time Table

[rwunderlich]

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

[Anonymous]

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.

[rwunderlich]

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

[Anonymous]

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

[oknotsen]

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 .