topic Re: Hi .. I am stuck !! Please Create extra lines in a script in QlikView

Hi .. I am stuck !! Please Create extra lines in a script

phb_nostromo — Wed, 25 Nov 2020 16:16:04 GMT

I would like to reach the following result from that type of data.

Simply to be able to create extra lines when a a task ( DutyMinutes ) has to be repeated over a few weeks.

for instance, the third line will have two lines as a result as it covers weeks 25 and 26 of 2017.

I tried to use peek in resident table but got totally lost !

Any help please ?

Employee	DutyMinutes	WeekStart	WeekEnd
S. BOLlQUIER	20	201724	201724
S. BOLlQUIER	15	201725	201725
S. BOLlQUIER	20	201725	201726
S. BOLlQUIER	35	201726	201728

Employee	DutyMinutes	Week
S. BOLlQUIER	20	201724
S. BOLlQUIER	15	201725
S. BOLlQUIER	20	201725
S. BOLlQUIER	20	201726
S. BOLlQUIER	35	201726
S. BOLlQUIER	35	201727
S. BOLlQUIER	35	201728

Re: Hi .. I am stuck !! Please Create extra lines in a script

tamilarasu — Mon, 26 Feb 2018 17:03:34 GMT

Hi Philippe,

Data:
LOAD * INLINE [
    Employee, DutyMinutes, WeekStart, WeekEnd
    S. BOLlQUIER, 20, 201724, 201724
    S. BOLlQUIER, 15, 201725, 201725
    S. BOLlQUIER, 20, 201725, 201726
    S. BOLlQUIER, 35, 201726, 201728
];

Result:  
LOAD  
  Employee,
  DutyMinutes,  
  WeekStart + IterNo() -1 as Week   
Resident Data  
While WeekStart + IterNo()-1 <= WeekEnd; 

DROP Table Data;

Re: Hi .. I am stuck !! Please Create extra lines in a script

phb_nostromo — Tue, 27 Feb 2018 07:15:36 GMT

Hi Tamil !

Thanks a lot works like a Wonder .

have a nice day

Re: Hi .. I am stuck !! Please Create extra lines in a script

tamilarasu — Tue, 27 Feb 2018 07:43:08 GMT

Great. You too have a fantastic day, Philippe.