Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
It works now, see the script! The peek needed to be in the previous, not the other-way around.
Jordy
Climber
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
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
Hi PrashantSangle,
thanks a lot for your Feedback, but it does not work
i mean: i used the peek()- function and it does not work, i attached my qlik sense example (see above).
thanks a lot
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
Hi,
It works now, see the script! The peek needed to be in the previous, not the other-way around.
Jordy
Climber
Jordy thanks a lot for your time and help