Discussion Board for collaboration related to QlikView App Development.
I am having date and I need New date fields's data should be like below. How can I achieve this at script level as a new field using peek or previous functions.
load Date#(Date,'DD-MM-YYYY') as Date;
load * inline
load Date, Previous(Date) as New_Date
order by Date desc;
Thanks for your inputs, but not getting exact result.
load Date#(Date,'DD-MM-YYYY') as Date ;
previous(Date) as NewDate
drop table A;
Sorry, i missed drop table part.
Please refer below code.