topic Re: Creating new fields on existing QVD in App Development

Creating new fields on existing QVD

Nolan — Sat, 16 Nov 2024 00:54:41 GMT

Hello,

I currently have a QVD file with the following script:

LOAD
"Day",
"Location",
DOH,
"Ending Inventory",
ID,
"In Transit",
"Lost Sales",
"On Order",
"Product Desc",
Receipts,
Sales

FROM [lib://QVD Storage (ngavin)/INVHIST.qvd]
(qvd);

After initially loading this script into the app, I have been able to create this new field and subsequently load it as well:

"Location" & "Product Desc" as LocationProdKey

I am currently trying to add another field, but am running into an error titled 'Invalid Expression'

The new field I'm trying to add is :

Max("Day") as "MaxDay"

Is there a reason I am not able to add this 'MaxDay' field the same way I did the 'LocationProdKey'?

Thanks in advance

Nolan

Anil_Babu_Samineni — Tue, 22 Dec 2020 18:19:02 GMT

When you use Aggregate function you have to declare the group by for all non aggregate fields. Perhaps you can try this way

Table:

LOAD
"Day",
"Location",
DOH,
"Ending Inventory",
ID,
"In Transit",
"Lost Sales",
"On Order",
"Product Desc",
Receipts,
Sales

FROM [lib://QVD Storage (ngavin)/INVHIST.qvd]
(qvd);

Left Join (Table)

Load Max(Day) as MaxDat Resident Table;

Nolan — Tue, 22 Dec 2020 18:36:06 GMT

Thank you so much!