Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

agg in the script

What am I doing wrong?

[Min PPU]:

Load

Family,

Scenario

,

[Product Name]

,

[Total Purchase Cost]

,

[Minimum Desired Quantity],

If

(([Product Name]=Previous([Product Name]) and Scenario = Previous(Scenario)),

min



([Total Purchase Cost]/[Minimum Desired Quantity]) as [MinPPU per P]))

resident

Main

order

by

Family



,Product,Scenario;

Main:

LOAD

Supplier,

Category,

[Item Name],

[Minimum Desired Quantity],

Segment,

Family,

[Article number],

[Component number],

Scenario,

[Product Name],

[Article/Component],

[Price Per Unit],

[Historical Cost],

[Total Historical Cost],

[Total Purchase Cost],

[Projected Savings],

from

blablabla;



2 Replies
Qlik_Trigg
Employee
Employee

what error is happening?

Not applicable
Author

maybe the last comma just before the fronm

[Projected Savings],

from

blablabla;