How to calculate Average Qty per day

[rabbani_sk]

Hi all,

I need to Caluculate the Average Quantity of an item , depending up the days filtered in calendar object...

Urgent Requirement ! Any idea?

[#2]

try the below expression

sum(Quantity)/aggr(Sum(Quantity) item)

Regards,

Kabilan K.

[#3]

Can you please post some sample application.

[rabbani_sk]

I am using below expression, and the stated the script for Calendar object,

=fabs(Sum({<[Item Ledger Entry Type]={1,3,5},[Posting Date]={'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'}>}Quantity))

so for this i want to caluculate the average qty dynamically with the change in dates in the Calendar Object

Note: i didnt not used any  Date field in dimension, i used only item no, item category

[VishalWaghole]

Hi,

Please Try this

avg(aggr(sum(Quantity), Item))

Hope that will solve your problem.

Thanks

[jagan]

Hi,

Try this

http://community.qlik.com/blogs/qlikviewdesignblog/2013/07/29/averages

sum(Quantity)/Count(Distinct DateFieldName)

Hope this helps you.

Regards,

jagan.