This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
on the below Input recordset I'd like to add EndDate that would be equivalent of following StartDate - 1 partitioned by Id just like in SQL - LEAD(StartDate) OVER (PARTITION BY Id ORDER BY StartDate). Any idea how to do it?
May be this:
(html, codepage is 1252, embedded labels, table is @1);
If(Id = Peek('Id'), Date(Peek('StartDate') - 1)) as EndDate
Order By Id, StartDate desc;
DROP Table Table;
View solution in original post
Perfect, thank you, Sunny!
Not a problem
I am glad I was able to help