Skip to content

Instantly share code, notes, and snippets.

@mountaindude
Last active January 23, 2018 10:43
Show Gist options
  • Save mountaindude/7508720820c1953937b6 to your computer and use it in GitHub Desktop.
Save mountaindude/7508720820c1953937b6 to your computer and use it in GitHub Desktop.
QlikView and Qlik Sense date variables
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'));
@saran7de
Copy link

Great one

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment