Simple LOAD ...GROUP BY - Invalid Expression

chris1987 — Sat, 16 Nov 2024 03:04:21 GMT

Hi,

Please can someone point out where I'm going wrong with the below syntax.

It should be straight forward but I'm obviously missing something as I'm getting an "Invalid Expression" error, but no indication to why. All fields exist in the "QuoteInfo" table.

Cheers

Chris

Load upper("QLI_Ar-entity") & '|' & upper("Quote No") & '|' & upper("Quote Version No") as "QuoteKey",
"QLI_Ar-entity",
"Quote No",
"Quote Version No",
"QI_Quote-status",
SUM("QLI_calc-gross" * "QLI_Qty-orig-quo") as QuoteTotalGross,
SUM("QLI_calc-net" * "QLI_Qty-orig-quo") as QuoteTotalNet
Resident QuoteInfo
GROUP BY "QLI_Ar-entity","Quote No","Quote Version No";

Re: Simple LOAD ...GROUP BY - Invalid Expression

chris1987 — Mon, 08 Jul 2019 11:47:35 GMT

Spotted it the second I posted this question, I wasn't including "QI_Quote-status" in the group.

Thanks

Chris

Corrected:

topic Re: Simple LOAD ...GROUP BY - Invalid Expression in QlikView

Simple LOAD ...GROUP BY - Invalid Expression

Re: Simple LOAD ...GROUP BY - Invalid Expression