Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a data source link this:
//Price: (one ItemName may included several price, so used the average price to calculate)
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,
sorry, this way i have test but donot work.
can somebody help to analysis this again?
Just try out sum(aggr(sum(Qty)*avg(price),ItemName))
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