How Can i calculate Average Days between Order Date And Shipment Date?

[Saurabh_Soni]

Hello everybody,

I'am using Qlik sense Desktop. I'am unable to get the desired output for my question.

First i calculated Days between Order Date and Shipment Date in script as:       Day([Ship Date]) - Day([Order Date]) as days;

Here i get the difference days in seperate column. Now i want to find Average of difference days according to Sub-Category wise example:- chairs, art etc. Here i don't get the the desired output. i have attached an image. kindly help me. Thank you

[dplr-rn]

try changing the script column to below

 Interval([Ship Date]-[Order Date],'D') as day