Problems when using Distinct/Data Joins - Qlik Community

Dayna · ‎2012-02-23

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

jvitantonio · ‎2012-02-23

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?

Report Inappropriate Content · ‎2012-02-23

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 · ‎2012-02-23

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