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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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