Creating new fields on existing QVD

[Nolan]

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 · Accepted solution]

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]

Thank you so much!