how to create a month

Mon, 26 Jan 2026 18:19:17 GMT

I am having the field calender week from this one i need to create month how to do it

Re: how to create a month

Anonymous — Mon, 04 Feb 2013 18:51:35 GMT

hi,

can you please provide sample data.

Regards

Re: how to create a month

Bill_Britt — Tue, 05 Feb 2013 13:41:11 GMT

Do you have a field that contains a date? If so then the below should work.

Month(Fieldname) as Month,

Orders:

LOAD

applymap('Shippers_Map', ShipperID, 'MISSING') as Shipper,

ShipperID,

CustomerID,

    EmployeeID,

    EmployeeID as EmployeeSalesID,

    Freight,

    OrderDate,

    Month(OrderDate) as Month,

    Year(OrderDate) as Year,

    Day(OrderDate) as Day,

    applymap('Quarters_Map', num(Month(OrderDate)), Null()) as Quarter,

    date(monthstart(OrderDate),'MMM-YYYY') as MonthYear,

    OrderID,

    1 as OrderIDCounter

;

SQL SELECT *

FROM Orders

order by OrderDate ASC;

Bill

topic how to create a month in QlikView

how to create a month

Re: how to create a month

Re: how to create a month