Discussion Board for collaboration on QlikView Scripting.
i have a question, and i do not know how to achieve it in loading script. i have created a sample qvw. and a screenshot.
user would like to create a new field - product_id & name(based on latest create_date). user wants the productID concantenate with a name of last creation date.
First change the date format at the top of your script so that your dates are properly recognised:
SET TimestampFormat='D/M/YYYY h:mm:ss[.fff] TT';
Then add this after the inline load:
product_id & FirstSortedValue(name, -create_date) as newField
Group By product_id;
YES!! Thanks! i didnt know firstsortedvalue can be used at the back, most of the time, i used it at front end set analysis!