Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikmpate0
Creator II
Creator II

missing records when using concatenation

I'm using concatenation to create the data I need, but pre concatenation I have the records I need to get the final figure, but when I use concatenation, some of my records are missing giving me different totals. When I add a field I then get the totals I need. Although the field I add is not a key field. Can any one help or has anyone experienced this?

regards

M

10 Replies
qlikmpate0
Creator II
Creator II
Author

My Solution to this was to use group by rather than distinct as swehl suggested. the distinct is using the distinct records from the unshipped table and then concatenating the records on to that table which then does a distinct hence losing the records that I need.

Thank you for all your help.

regards

M