Discussion Board for collaboration on QlikView Scripting.
I have a table which shows roster periods and when they were published. I want to include something in the script which identifies the latest published date. My table is below :
I want to add a line in the script which does the following :
Could anyone help ?
Hi Phil, after you have loaded your table you can add the text to the record using 'first' and 'order by', ie:
First 1 LOAD *, 'Latest Published' as Latest_Published resident Data where Published='Y' order by Publish_Date desc, PK_Date desc;