Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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;