Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creating replicating rolling dates

hi everyone

I have a script that create andload rolling dates.I want to create the same date three time and put a corresponding country adjacent to each of the three similar date .The script is given below can anyone help me with on how to make the reqired script

LOAD Date($(rEndDate)-IterNo()+IterNo()) as Date,

Date($(rStartDate)+IterNo()-1)as RollDate

AutoGenerate 1 While $(rStartDate) + IterNo() -1 <= $(rEndDate); 

NEXT i ;

0 Replies