Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Date Table QVW

hugmarcel
Contributor III

Date Table QVW

Hi

I provide this date table creation subroutine to you. The fields are all calculated with QV functions, thus "native".

Define start and end day, and you will get a table with 27 useful date fields, such as:

- DD.MM.YYYY, MM.YYYY etc.

- Julian
- Weekday Name Short
- Weekday Name Long
- Sort and number fields
- Padded fields (M01 2015, W01, etc.)

- W53 correction
- etc.

The script may need minor adaptions, following your local settings.

Regards - Marcel

Labels (2)
Attachments
Comments
MVP
MVP

TFS

Version history
Revision #:
1 of 1
Last update:
‎05-12-2015 11:43 AM
Updated by: