fill out the rows

[beck_bakytbek]

Hi Folks,

i have a Question, i am trying to fill out the rows in script area, but i don't have the expected Output, my table does look like:

Project	Data	Empl	Amount
2001	02.02.2017	12	30
2001	03.02.2017	-	-
2001	04.02.2017	18	20
2001	05.02.2017	-	-
2001	06.02.2017	-	-
2001	07.02.2017	-	-
2001	08.02.2017	14	10

and my expected Output is:

Project	Data	Empl	Amount
2001	02.02.2017	12	30
2001	03.02.2017	12	30
2001	04.02.2017	18	20
2001	05.02.2017	18	20
2001	06.02.2017	18	20
2001	07.02.2017	18	20
2001	08.02.2017	14	10

Does anybody have any idea how to resolve this issue?

Thanks a lot

[JordyWegman]

Hi Beck,

You can try the following:

Table:
Load
  Project,
  Data,
  IF(Isnull(Empl), previous(Empl),Empl) as Empl
  IF(Isnull(Amount),previous(Amount),Amount) as Amount
From [YourSource](qvd);

Jordy

Climber 

[beck_bakytbek]

Hi Jordy,

thanks a lot for your responce and Feedback, i tried to implement your Suggestion, but i didnt achieve any results, i attached my qlik Sense - example

[PrashantSangle]

instead of previous () use peek ()

if(isnull(Amount),peek(Amount),Amount) as Amount

Regards,

[beck_bakytbek]

Hi PrashantSangle,

thanks a lot for your Feedback, but it does not work

[PrashantSangle]

what do you mean by not working. can share your screen shot of it.

[beck_bakytbek]

i mean: i used the peek()- function and it does not work, i attached my qlik sense example (see above).

thanks a lot

[lironbaram · Accepted solution]

hi 

after you loaded the initial table 

let call the table : Table1

you can add to your script 

Table2:

noconcatenate load Project,

                                          Data,

                                         if(isnull(Empl),peek('Empl'),Empl) as Empl

                                         if(isnull(Amount),peek('Amount'),Amount) as Amount

resident Table1

order by Project,Data;

drop table Table1

load 

[JordyWegman · Accepted solution]

Hi,

It works now, see the script! The peek needed to be in the previous, not the other-way around.

Jordy

Climber

[beck_bakytbek]

Jordy thanks a lot for your time and help