Discussion Board for collaboration on QlikView Scripting.
I Have a Table contains 2 columns, I want to add to this table 'To Date' column contains next row 'From Date' minus a day.
Can someone have an efficient way to do that?
Go to Solution.
LOAD * Inline [
Product, From Date
If(Product = Peek('Product'), Date(Peek('From Date') - 1), Date(Today())) as [To Date]
Order By Product, [From Date] desc;
DROP Table Table;
Perhaps like this:
LOAD Product, Date FROM ...source;
If( Product =Previous(Product),Previous(Date), Date(Today(),'DD/MM/YYYY')) as [To Date]
Order By Product, Date desc;