Skip to content

Instantly share code, notes, and snippets.

@ralfbecher

ralfbecher/QlikView_WeekName_to_Date.qvs

Created September 2, 2013 10:34
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ralfbecher/6411508 to your computer and use it in GitHub Desktop.
Save ralfbecher/6411508 to your computer and use it in GitHub Desktop.
Download ZIP
Converts a given weekname (eg. 2013/36) to the starting date of the week. Opposite of QlikView WeekName() function.
Raw
QlikView_WeekName_to_Date.qvs
// Convert weekname (eg. format YYYY/WW) to date:
=MakeWeekDate(subfield(field, '/', 1), subfield(field, '/', 2), 0)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment