Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Amruta
Contributor
Contributor

Assigning values to the Dates

Hi all,

I have a below task where i need to allocate or fill the values for the dates,where ther is no data availble in the excel,

I have generated the dates in using master calender ,but not sure how do i assign those values to those dates .Below is my scenario.

Data i have as below:

Activity Start Date  End date
A 1/1/2021 3/1/2021
D 4/1/2021 6/1/2021
F 7/1/2012 9/1/2021

 

Result I required:

Activity Date Start Date  End date
A 1/1/2021 1/1/2021 3/1/2021
A 2/1/2021    
A 3/1/2021    
D 4/1/2021 4/1/2021 6/1/2021
D 5/1/2021    
D 6/1/2021    
F 7/1/2012 4/1/2021 9/1/2021
F 8/1/2012    
F 9/1/2012    

 

How i get this column date with respect to activity start date and end date,Please help if any ideas.

Labels (3)
2 Replies
tresesco
MVP
MVP

tresesco_0-1643010899410.png

Load Activity,
	If(IterNo()=1, "Start Date") 	as "Start Date",	
	If(IterNo()=1, "End Date") 	as "End Date",
	Date("Start Date"+IterNo()-1) 	as Date
While "Start Date"+IterNo()-1<="End Date";

Load	* Inline [
Activity,	Start Date, 	End Date
A,	1/1/2021,	3/1/2021
D,	4/1/2021,	6/1/2021
F,	7/1/2021,	9/1/2021]