Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
sorry, this way i have test but donot work.
can somebody help to analysis this again?
thank you
Just try out sum(aggr(sum(Qty)*avg(price),ItemName))
Regards,
Kiran.
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