Last active
January 23, 2018 10:43
-
-
Save mountaindude/7508720820c1953937b6 to your computer and use it in GitHub Desktop.
QlikView and Qlik Sense date variables
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
let vStartOf2ndPreviousQuarter = Date(Floor(QuarterStart(Today(), -2)), 'YYYY-MM-DD'); | |
let vStartOf2ndPreviousQuarterNum = Num(Date(Floor(QuarterStart(Today(), -2)), 'YYYY-MM-DD')); | |
let vStartOfPreviousQuarter = Date(Floor(QuarterStart(Today(), -1)), 'YYYY-MM-DD'); | |
let vStartOfPreviousQuarterNum = Num(Date(Floor(QuarterStart(Today(), -1)), 'YYYY-MM-DD')); | |
let vStartOfCurrentQuarter = Date(Floor(QuarterStart(Today())), 'YYYY-MM-DD'); | |
let vStartOfCurrentQuarterNum = Num(Date(Floor(QuarterStart(Today())), 'YYYY-MM-DD')); | |
let vStartOfPreviousMonth = Date(Floor(MonthStart(Today(), -1)), 'YYYY-MM-DD'); | |
let vStartOfPreviousMonthNum = Num(Date(Floor(MonthStart(Today(), -1)), 'YYYY-MM-DD')); | |
let vStartOfCurrentMonth = Date(Floor(MonthStart(Today())), 'YYYY-MM-DD'); | |
let vStartOfCurrentMonthNum = Num(Date(Floor(MonthStart(Today())), 'YYYY-MM-DD')); | |
let vYesterday = Date(Today()-1, 'YYYY-MM-DD'); | |
let vYesterdayNum = Num(Date(Today()-1, 'YYYY-MM-DD')); | |
let vToday = Date(Today(), 'YYYY-MM-DD'); | |
let vTodayNum = Num(Date(Today(), 'YYYY-MM-DD')); | |
let vTomorrow = Date(Today()+1, 'YYYY-MM-DD'); | |
let vTomorrowNum = Num(Date(Today()+1, 'YYYY-MM-DD')); | |
let vEndOfCurrentMonth = Date(Floor(MonthEnd(Today())), 'YYYY-MM-DD'); | |
let vEndOfCurrentMonthNum = Num(Date(Floor(MonthEnd(Today())), 'YYYY-MM-DD')); | |
let vEndOfNextMonth = Date(Floor(MonthEnd(Today(), 1)), 'YYYY-MM-DD'); | |
let vEndOfNextMonthNum = Num(Date(Floor(MonthEnd(Today(), 1)), 'YYYY-MM-DD')); | |
let vEndOfCurrentQuarter = Date(Floor(QuarterEnd(Today())), 'YYYY-MM-DD'); | |
let vEndOfCurrentQuarterNum = Num(Date(Floor(QuarterEnd(Today())), 'YYYY-MM-DD')); | |
let vEndOfNextQuarter = Date(Floor(QuarterEnd(Today(), 1)), 'YYYY-MM-DD'); | |
let vEndOfNextQuarterNum = Num(Date(Floor(QuarterEnd(Today(), 1)), 'YYYY-MM-DD')); | |
let vEndOf2ndNextQuarter = Date(Floor(QuarterEnd(Today(), 2)), 'YYYY-MM-DD'); | |
let vEndOf2ndNextQuarterNum = Num(Date(Floor(QuarterEnd(Today(), 2)), 'YYYY-MM-DD')); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Great one