Fill the missing data in QlikView

[rjn]

Dear All,

I am working on to fill the missing data in the existing table in QlikView, below is the scenario, any help would be highly appreciated.

Table A: (Already exists in QlikView Data model)

Should update as highlighted in yellow after reload

Table B:

Regards,

J. Ravichandra Kumar

[rjn]

Hi Gysbert,

Sorry for the brevity.

below is the date we have in our QVD file. The requirement is, we need to show Category "In-Progress" months. i.e., CR ID 'a0CD000000f6R4aMAE' category changed to In-Progress in Feb-2014, so we should count this CR ID in 'In-Progress' status for Feb-2014, Mar-2014, Apr-2014, and May-2014. The same should repeat for other Categories except 'Completed' Status.

Regards,

J. Ravichandra Kumar

[Gysbert_Wassenaar]

Perhaps like this:

Temp:

LOAD

     [CR ID],

     [Month Year],

     [CR Category]

FROM

     sourcetable;

Result:

LOAD

     [CR ID],

     Date(AddMonths([Month Year],IterNo()-1),'MMM-YYYY') as [Month Year],

     [CR Category]

WHILE

     AddMonths([Month Year],IterNo()-1) < NextMY

     ;

LOAD

     [CR ID],

     [Month Year],

     [CR Category],

     If(Previous([CR ID])=[CR ID], Previous([Month Year]),[Month Year]+1) as NextMY

RESIDENT

     Temp

ORDER BY [

     CR ID], [Month Year] Desc

     ;

DROP TABLE Temp;