Generate Order No. for those months where there's no record for it

[DataNovice01]

Hi,

I need to generate missing Order Nos. and the filled count for those months where that particular Order No. is not present and generate '0' as filled count. Something as shown in the image. Thanks.

[lironbaram]

hi 

assuming your table is called Table1 

this script should work 

Table2:
load *,
     if(isnull(OrderNo),peek('FullOrder'),OrderNo) as FullOrder
resident Table1
order by OrderNo,Month;

[DataNovice01]

Hi.. tried this but it still does not generate the additional months for a particular OrderNo. if it wasn't there in the month. There's no difference between Orcer and FullOrder.

[Brett_Bleess]

Finally found the Design Blog post I was looking for on this one, have a look, I believe it may give you an avenue:

https://community.qlik.com/t5/Qlik-Design-Blog/How-to-populate-a-sparsely-populated-field/ba-p/14706...

Regards,
Brett