Continuous Value (Data)

[beck_bakytbek]

Hi Folks,
i got  a Question, i have my table:

ProjNr, Data, Employee, Amount

2001, 02.02.2017, 12, 20
2001, 04.02.2017, 12, 20
2001, 08.02.2017, 14, 10

Does anybody have any idea, how can i make my column: Data as continuous Data, i mean by that this output

ProjNr, Data, Employee, Amount, 

2001, 01.02.2017, -, -
2001, 02.02.2017, 12, 20
2001, 03.02.2017, -, -
2001, 04.02.2017, 12, 20
2001, 05.02.2017, -, -
2001, 06.02.2017, -, -
2001, 07.02.2017, -, -
2001, 08.02.2017, 14, 10

Does anybody have any idea how to resolve this issue?

Thanks a lot

Beck

[Vegar]

I'm not really sure if I understand your question @beck_bakytbek . Please rephrase or attach some picture sample to explain further.

Peek will work as long you are loading the field you are peeking into the end table. In my example I do a check if the employee has changed from the previous row or not.

[beck_bakytbek]

Vegar,

thanks a lot for your responce, i created the issue with Name: fill out the rows, where i attached example.

thanks a lot

[beck_bakytbek]

Hi Vegar,

here is my Qlik Sense - Example

[Vegar]

Is this what you want?

Then you can run this script

test:
load * Inline [
ProjNr, Data, Empl, Amount
2001, 02.02.2017, 12, 30
2001, 04.02.2017, 18, 20
2001, 08.02.2017, 14, 10
];

temp:
load
min(Data) as MinDate,
max(Data) as MaxDate
Resident test;
let vMinDate = peek('MinDate');
let vMaxDate = peek('MaxDate');

drop Table temp;


for _date = $(vMinDate) to $(vMaxDate)

PrjDate:
LOAD
dayname($(_date)) as Data
AutoGenerate 1;
next 

Join(PrjDate)
load Distinct
ProjNr
Resident test;


join(test)
load *
Resident PrjDate;

drop Table PrjDate;



final:
load
  ProjNr as Projekt,
  Data,
  if(isnull(Empl), Peek('Empl') , Empl) as Empl,
  if(isnull(Amount), Peek('Amount') , Amount) as Amount
Resident test
order by  Data,Empl;
;
drop Table test;