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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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;