Discussion board where members can get started with Qlik Sense.
I have sample data as shown below
The requirement is to fill the intermediate missing dates with previous sales values as something like shown below
I was trying to use peek and previous condition but not able to replicate it exactly.
Any help is appreciated.
Date(Date#([Transaction Date], 'DD-MMM-YY')) as 'Start date'
Reporter ID, Transaction ID, Transaction Date, Sales
R1, T1, 1-Jan-19, 100
R1, T1, 5-Jan-19, 80
R1, T1, 10-Jan-19, 60
R1, T1, 15-Jan-19, 40
alt(Peek([Start date]), [Start date]) as 'End date'
Order by [Reporter ID],
[Start date] desc;
drop Table tmp;
Date([Start date] + IterNo() - 1) as 'Transaction Date'
While [Start date] + IterNo() - 1 < [End date];
drop Table Periods;