topic Data duplicates in straight table in QlikView

Data duplicates in straight table

Fri, 06 Jun 2014 06:30:05 GMT

Hi, Comminity!

Please help dummy. I've got double result in some rows of straigh table, though the table viewer says that data model looks to be correct.

Thank you!

Re: Data duplicates in straight table

alexandros17 — Fri, 06 Jun 2014 06:35:42 GMT

Probably it is correct, a table has a 1:n relation with another so for a value of the first you see more values for the second.

Check tables loading in couples and verify where is the 1:n relation

Hope it helps

Re: Data duplicates in straight table

amit_saini — Fri, 06 Jun 2014 06:38:05 GMT

Alexei,

Please follow this :

How to remove duplicates

Thanks,
AS

Re: Data duplicates in straight table

Peter_Cammaert — Fri, 06 Jun 2014 06:38:45 GMT

Probably a problem in the link table at the right. IMHO you'll find two entries inthere, one that connects to an entry in the top right table, and one that either contains a value that has no counterpart in the top table, or that equals NULL in the top field.

If the right table isn't too big, use the Preview function to inspect its contents.

Sorry that I cannot be clearer with table and field names, but I don't have cyrillic characters on my keyboard.

Re: Data duplicates in straight table

Fri, 06 Jun 2014 09:41:12 GMT

Peter, thank you very much for your help.

I have only one record "Юридический отдел" in the field "Подразделение". And as far as I understand, "ЮРО" has its counterpart int the top field.

Re: Data duplicates in straight table

Fri, 06 Jun 2014 09:56:12 GMT

Amit, thank you very much.

But I think I have less complicated problem.

No aggregations...

Re: Data duplicates in straight table

Fri, 06 Jun 2014 10:12:25 GMT

I think the cause is in your data or in your data model.
Make an examination on your data

Some links that could help you (check out):

http://www.quickintelligence.co.uk/qlikview-data-profiler/

http://blog.qvapps.com/2009/04/15/tutorial-1-system-fields/

Re: Data duplicates in straight table

anbu1984 — Fri, 06 Jun 2014 10:18:09 GMT

can you post sample qvw.

Re: Data duplicates in straight table

Fri, 06 Jun 2014 10:21:04 GMT

Alessandro, thank you very much.

As far as I understans, the table "труд" has only 1:1 relations.

I may be wrong of course, being a very beginner.

Thanks again!

Re: Re: Data duplicates in straight table

Fri, 06 Jun 2014 11:14:04 GMT

Sure.

Thanks.

Re: Data duplicates in straight table

anbu1984 — Fri, 06 Jun 2014 12:29:39 GMT

It seems like you have duplicates in your input. Can you attach input files.

Re: Re: Data duplicates in straight table

Fri, 06 Jun 2014 13:06:14 GMT

Yes, of course. Thank you, Anbu!

Re: Re: Data duplicates in straight table

Fri, 06 Jun 2014 13:10:51 GMT

Yes, of course. Thank you, Anbu!