Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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 ;

Community Browser