expression aggregate for supplier

andyrebs — Mon, 13 May 2013 17:40:13 GMT

Dear All,

I need a very helpfull information from you.

I have an expression that show me the lead time of the supplier, using as a dimension the IdSupplier.

This expression is =NUM(AVG(OrderArrivalDate-OrderDate),'#.##0')

I modified this expression, as suggested in this community, to have the forecast of OrderArrivalDate using the avg in a chart with the ID Order as dimension

alt(OrderArrivalDate, OrderDate + avg({<OrderDate>}total <[IdSupplier]> OrderArrivalDate-OrderDate)

This expression works quite well, but only if i select a specific Supplier.

I need that this expression shows the avg of each supllier, not the avg of all supllier with out any selection on the suppliers

I attach the chart for your perusal

The Forecast Date should be different for each order's supplier. In red I highlight that the difference of two dates is always the same

I hope you can help me, because it is very important for my schedules.

Many thanks

Best regards

Andrea

Re: expression aggregate for supplier

vikasmahajan — Tue, 14 May 2013 06:30:54 GMT

CAN U ATTACH SMALL DEMO WHAT EXACT U WANT

topic Re: expression aggregate for supplier in QlikView

expression aggregate for supplier

Re: expression aggregate for supplier