Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
andyrebs
Contributor III
Contributor III

expression aggregate for supplier

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

1 Reply
vikasmahajan

CAN U ATTACH SMALL DEMO WHAT EXACT U WANT

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.