If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
how can I remove duplicates from this table based on the first field?
Try using Distinct (HRdataset_V9.Employee) , if not working try removing the null value check in the expression
@Giwa_Temitopoluwa I think you can uncheck include Null Values in the 2nd Dimension in the straight table.
Quickest answer as suggested by @sidhiq91 ,
I would be tempted to look into the data model to find out why you have duplicates when you are not expecting them.