Data duplicates in straight table

[#1]

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!

[alexandros17]

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

[amit_saini]

Alexei,

Please follow this :

How to remove duplicates

Thanks,
AS

[Peter_Cammaert]

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.

[#5]

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.

[#6]

Amit, thank you very much.

But I think I have less complicated problem.

No aggregations...

[#7]

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/

[anbu1984]

can you post sample qvw.

[#9]

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!

[#10]

Sure.

Thanks.