MonthName(Created) as YearMonth,
(ooxml, embedded labels, table is DATA);
Sum(Length) as TotalLength,
Sum(Width) as TotalWidth,
Sum(Height) as TotalHeight
Group by YearMonth,CustID,Location;
DROP Table Data;
Kindly find the attached Sample Application.
1505208.qvw 155.2 K
LOAD text(DATE([Created],'MMMYYY')) as StockDate2,
sum(TotalQty) as Receipted2,
sum([Length])/2.54 as Length,
sum([Width])/2.54 as Width,
sum([Height])/2.54 as Height
Resident [L2-LocationInventory] group by CustID, Location, text(DATE([Created],'MMMYYY'));
Even if you covert the date using date format, Qlik will store original date as value so it will not work for aggregation (Like Excel only outside format will be changed but not value).