Discussion Board for collaboration on QlikView Scripting.
I'm trying to load, for all of my customers, the first date they ordered.
I have 2 tables which are basically as following :
I'd like to add a column in my "CUSTOMERS" table which would be the first order date (i want it to be pre-calculated in the script, not calculated within the report).
Thanks in advance for your help !
Go to Solution.
Try a grouped by load with FirstSortedValue aggregation:
left join (CUSTOMERS) LOAD
FirstSortedValue(order_date, order_date) as FirstOrderDate
resident ORDERS group by customer_id;
to your script, after the above posted lines.
I assume that order_date is of Date type with numerical representation.
Hope this helps,
Thank you very much ! It works perfectly !