Discussion Board for collaboration on QlikView Scripting.
Just some scripting wisdom is in need, if I have a record as follows.
If I want to repeat this record depending on the Duration number i.e 5 how would I do that.
So my resulting data set should be
Go to Solution.
Date(StartDate + IterNo()-1) as Date,
[https://community.qlik.com/thread/240200](html, codepage is 1252, embedded labels, table is @1)
while IterNo() <= Duration;
View solution in original post
Something like this:
Date(StartDate + IterNo()) - 1 as Date
WhereWhile IterNo() < Duration;
Thanks for the prompt response,
But the "From" part does not seem clear enough, Is it supposed to be autogenerate or the same table . If it is the same table as
Then this will be producing only 1 row. How will it create 5 rows.
Yes the While clause does the trick.
Thanks a million