Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Manish2109
Contributor II
Contributor II

How To generate all Dates based on Random dates column.

Hi Team, 

We have requirement to generate all the dates a Date column based on the Random date column we have. See below the attached data:

Id Resource Date Value
201 13-01-2024 100
201 17-01-2024 200
201 22-01-2024 300
401 13-01-2024 150
401 17-01-2024 250
401 22-01-2024 350

 

The result/Output which is required is : 

Id Resource Date Date Value
201 13-01-2024 13-01-2024 100
201 13-01-2024 14-01-2024 100
201 13-01-2024 15-01-2024 100
201 13-01-2024 16-01-2024 100
201 17-01-2024 17-01-2024 200
201 17-01-2024 18-01-2024 200
201 17-01-2024 19-01-2024 200
201 17-01-2024 20-01-2024 200
201 17-01-2024 21-01-2024 200
201 22-01-2024 22-01-2024 300
401 13-01-2024 13-01-2024 150
401 13-01-2024 14-01-2024 150
401 13-01-2024 15-01-2024 150
401 13-01-2024 16-01-2024 150
401 17-01-2024 17-01-2024 250
401 17-01-2024 18-01-2024 250
401 17-01-2024 19-01-2024 250
401 17-01-2024 20-01-2024 250
401 17-01-2024 21-01-2024 250
401 22-01-2024 22-01-2024 350

 

Please suggest how we can achieve the above result.

Labels (2)
1 Reply