Quarter Creation

[akpofureenughwu]

How do I create a quarter period in my script. Please find the attached file for clarity. Thanks

[sunny_talwar]

This:

NoConcatenate

LOAD [S/N],

     [Supply Field],

     If(Len(Trim(Region)) = 0, Peek('Region'), Region) as Region,

     Supplier,

     Type,

     [Daily Average],

     [Annual Cumm],

     Date(Num#(Date)) as Date,

     Month(Num#(Date)) as Month,

     'Q' & Ceil(Month(Num#(Date))/3) as Quarter,

     MonthName(Num#(Date)) as MonthYear,

     Year(Num#(Date)) as Year,

     Value

[akpofureenughwu]

Thanks Man. How about the day of the month in the script?

[sunny_talwar · Accepted solution]

You can use Day() function for that:

NoConcatenate

LOAD [S/N],

    [Supply Field],

    If(Len(Trim(Region)) = 0, Peek('Region'), Region) as Region,

    Supplier,

    Type,

    [Daily Average],

    [Annual Cumm],

    Date(Num#(Date)) as Date,

    Month(Num#(Date)) as Month,

    'Q' & Ceil(Month(Num#(Date))/3) as Quarter,

    MonthName(Num#(Date)) as MonthYear,

    Year(Num#(Date)) as Year,

    Day(Num#(Date)) as Day,

    Value

I would suggest looking into a master calendar script for doing this:

Creating A Master Calendar‌

And for a list of date and time function, visit help:

Date and time functions ‒ QlikView