Filling missing data using Chart Functions

[abhiM]

Hello,

I am trying to fill in the missing Order Dates for Order Numbers in a QlikView table using Chart Functions I do not have the luxury of editing it in script. The sample data looks as follows

What I want is to fill in missing Order Dates by looking up order date for same order number. For Example ProductID C should have Order Date same as Product ID A, similarly Product ID B and G should have Order Date of D. 

Any ideas on how this can be achieved?

Thanks in advance for your help!

[sunny_talwar]

May be this as an expression

Aggr(NODISTINCT OrderDate, OrderNumber)

[abhiM]

Thanks for your reply Sunny. I tried with your recommendation, unfortunately it doesn't work. 

[sunny_talwar]

Would you be able to share a sample to show this?

[abhiM]

Sure, please see the image below.

I want ORDER_DATE 20181126 to show up for all ORDER_NOs  

[abhiM · Accepted solution]

Thanks for your help Sunny!

The Calc Dimension 

AGGR(MAX(ORDER_DATE), ORDER_NO)

Worked.