Group by Invalid expression

krish2459 — Sat, 16 Nov 2024 20:19:28 GMT

Hi,

We are trying to load data with group by cause.

But wer are getting error as INVALID EXPRESSION.

Below is the script.

Purchase_Orders:
LOAD
Purch.Doc.,
Item,
CoCd,
"Type",
D,
"Created on",
Vendor,
POrg,
PGr,
Crcy,
replace(ltrim(replace(Material, '0', ' ')), ' ', 0) as Material,
Quantity,
OUn,
"Net value",
Business,
"Inventory as of",
'DXR'as Flag
FROM [lib://AttachedFiles/DXR_Open PO's for DXR_7_22_2019.xlsx]
(ooxml, embedded labels, table is Header_PO);

join(Purchase_Orders)

LOAD
Purch.Doc.,
Item,
Schd.,
Deliv.date,
Stat.d.dte,
C,
Sched.qty.,
"GR qty",
// sum(Sched.qty.)-sum("GR qty") as "Open Qty",

sum(Sched.qty.) as sched_QTY,

Issued,
Business,
"Inventory as of",
'DXR'as Flag
FROM [lib://AttachedFiles/DXR_Open PO's for DXR_7_22_2019.xlsx]
(ooxml, embedded labels, table is Detail_PO);

Concatenate(Pruned_Unique)
PO_DXR:

load *
Resident Purchase_Orders group by Material;

Drop Table Purchase_Orders;

Thanks..

Re: Group by Invalid expression

Claudiu_Anghelescu — Mon, 05 Aug 2019 09:25:04 GMT

Try to list all dimensions not only Material in Group By clause

topic Group by Invalid expression in QlikView

Group by Invalid expression

Re: Group by Invalid expression