Discussion Board for collaboration related to Qlik Education.
Hello, I have this data table
I want to generate monthly data observing the occupation change date, how to do it in the script so that I have this result:
can he have more than two occupations? or always 2 as in the example
may be this helps,
Base:LOADName,Occupation,Change_Date as End,date(if(Name=peek(Name),previous(Change_Date),yearstart(Change_Date))) as Start;LOAD * INLINE [Name, Occupation, Change_DateJhon, Programmer, 01/03/2019Jhon, Program Analyst, 15/06/2019Jhon, Manager, 10/08/2019];
Base_1:Load*,date((Start +iterno()-1)) as DateResident BaseWhile Start +iterno()-1 < End;
drop table Base;