Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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
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