Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Support on the aggr functions and calculate

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?

Tags (1)
4 Replies
Not applicable

Support on the aggr functions and calculate

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

Not applicable

Support on the aggr functions and calculate

sorry, this way i have test but donot work.

can somebody help to analysis this again?

thank you

Not applicable

Support on the aggr functions and calculate

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

Regards,

Kiran.

Not applicable

Support on the aggr functions and calculate

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

Community Browser