If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Hi all, how to remove duplicated records and display only the last accessed record. i have inserted a diagram below as example reference. would like to do this in load editor.
current table, EmployeeTable:
Max(Date(last_accessed_date, 'YYYY-MM-DD')) as maxLastAccessedDate;
Group by name, maxLastAccessedDate;
error message: invalid max expression
Your group by is wrong. You need to group by the dimensions that is not aggregated in your table See suggestion below.
Load id, name, company,
Group by id, name, company;