Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Dayna
Creator II
Creator II

Problems when using Distinct/Data Joins

Hello All,

For some reason, after my data has been loaded and joined (outer joins and left joins) my sums and counts require the DISTINCT qualifier, as the value is 3 times bigger than it should be... But I don't think I can use the distinct qualifier on my sum calculations, as the value that returns is smaller than it should be (getting rid of genuine duplicates). What can I do?

Kind Regards,

Dayna

3 Replies
jvitantonio
Specialist III
Specialist III

Hi, this is thecorrect behavior in qlik. Can you please upload your app so I can tell you how to you the distinc function using ur example?

Not applicable

Hi Dayna,

I agree with Armin.

It looks like you loaded some data twice. Or the joins (joinfields) to merge your QV-tables do not fit (any more).

Btw: Using an outer join between table T1 and T2 is to combine every row of T1 with every row of T2. I need this very seldom, do you really want that?

HtH

Roland

Dayna
Creator II
Creator II
Author

Hello Both,

I found half the cause to my distinct problem, the table I was joining to was a conversion table, so it provided multiple rows for each record... This I've resolved.. Just checking the rest, but I think it might be the joins.

Many thanks,

Dayna