topic Re: Filling missing data using Chart Functions in QlikView

Filling missing data using Chart Functions

abhiM — Sat, 16 Nov 2024 19:35:30 GMT

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!

Re: Filling missing data using Chart Functions

sunny_talwar — Mon, 25 Nov 2019 14:13:14 GMT

May be this as an expression

Aggr(NODISTINCT OrderDate, OrderNumber)

Re: Filling missing data using Chart Functions

abhiM — Mon, 25 Nov 2019 18:12:15 GMT

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

Re: Filling missing data using Chart Functions

sunny_talwar — Mon, 25 Nov 2019 18:16:19 GMT

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

Re: Filling missing data using Chart Functions

abhiM — Wed, 27 Nov 2019 18:34:43 GMT

Sure, please see the image below.

I want ORDER_DATE 20181126 to show up for all ORDER_NOs

Re: Filling missing data using Chart Functions

abhiM — Wed, 27 Nov 2019 18:43:45 GMT

Thanks for your help Sunny!

The Calc Dimension

AGGR(MAX(ORDER_DATE), ORDER_NO)

Worked.