Support on the aggr functions and calculate

[#1]

I have a data source link this:

//Inventory_info:

Date

ItemName

Qty

Factory

//Price: (one ItemName may included several price, so used the average price to calculate)

ItemName

Price

I want to creat a trend chart for inventory value in different days, so i used the calculation as:

sum( aggr(sum(Qty),ItemName)*aggr(Price,ItemName)  )

can not achieve this, so how should i work on that? Any ideas?

[#2]

sum(aggr(sum(Qty),ItemName)*aggr(avg(Price),ItemName)) might work.You need to have a group function for aggr to work.

Hope this helps,

Kiran

[#3]

sorry, this way i have test but donot work.

can somebody help to analysis this again?

thank you

[#4]

Just try out sum(aggr(sum(Qty)*avg(price),ItemName))

Regards,

Kiran.

[#5]

thank you but still not work.

I have upload the sample data and my qlikview file, if possible you can check in it.

the name of it: how to use aggr function to build a trend chart