Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Giwa_Temitopoluwa
Contributor
Contributor

Joins

how can I remove duplicates from this table based on the first field?

3 Replies
Lakshminarayanan_J

Hi @Giwa_Temitopoluwa 

Try using Distinct (HRdataset_V9.Employee) , if not working try removing the null value check in the expression

Thank You!

Lakshminarayanan J
To help users find verified answers, please don't forget to use the "Accept as Solution" button
sidhiq91
Specialist
Specialist

@Giwa_Temitopoluwa I think you can uncheck include Null Values in the 2nd Dimension in the straight table.

mark6505
Partner - Master
Partner - Master

HI @Giwa_Temitopoluwa 

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.