2 Replies Latest reply: Dec 8, 2011 1:10 PM by sskirpan RSS

    Quarter to Date, Prior Quarter to Date in Calendar

      Attached is the date portion of my load script for creating month, quarter, yearquarter, year and yearmonth.  I've been told that we will now need current quarter to date and prior quarter to date for our graphs.  Can someone help me with the QTD and prior QTD code to add to my script?  I'm new to Qlikview so please keep it simple.  Thank you!

       
      
      MONTH(DATE#([Policy Inception Date],'DD-MMM-YY')) as DiscMonth,
      CEIL(MONTH(DATE#([Policy Inception Date],'DD-MMM-YY'))/3) as DiscQuarter,
      YEAR(DATE#([Policy Inception Date],'DD-MMM-YY'))&CEIL(MONTH(DATE#([Policy Inception Date],'DD-MMM-YY'))/3) as DiscYearQuarter,
      YEAR(DATE#([Policy Inception Date],'DD-MMM-YY')) as DiscYear,
      YEAR(DATE#([Policy Inception Date],'DD-MMM-YY')) &'_'&MONTH(DATE#([Policy Inception Date],'DD-MMM-YY')) as DiscYearMonth,