Discussion Board for collaboration related to QlikView Deployment.
I am having the field calender week from this one i need to create month how to do it
Go to Solution.
Do you have a field that contains a date? If so then the below should work.
Month(Fieldname) as Month,
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 Ordersorder by OrderDate ASC;
can you please provide sample data.