Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
evgeniystuchalk
Partner - Creator II
Partner - Creator II

Problem with key field in sales and customers tables

Hello! I have two data tables: Leads and Contacts. This tables connected by key field "Contact ID". I want use some dimensions, like "Tag", from Contacts table, to slice data from Leads table. But, I don't know why, when i'm using filter in field "Tag", report behave like there is no Lead, that match filtering condition. But this Leads exist, I know it . Why field "Contact ID" don't work like a key? What am i missing?

All detail in my video (sorry my poor English )

1 Solution

Accepted Solutions
evgeniystuchalk
Partner - Creator II
Partner - Creator II
Author

Solution founded! If you want use fields from additional table like dimensions for main table, YOU MUST CONNECT THEM ONLY WITH ONE KEY FIELD

This is correct conetion. Example of incorrect connection you can see in my video.

N6TMADGDQEiaKFZgEZCp3A.png

View solution in original post

4 Replies
evgeniystuchalk
Partner - Creator II
Partner - Creator II
Author

Solution founded! If you want use fields from additional table like dimensions for main table, YOU MUST CONNECT THEM ONLY WITH ONE KEY FIELD

This is correct conetion. Example of incorrect connection you can see in my video.

N6TMADGDQEiaKFZgEZCp3A.png

robert_mika
Master III
Master III

You have got synthetic keys:

not one field but multiple fields connects your tables cousing your issues

The $S.. indicates the

Look here how to get your data right

Synthetic Keys

evgeniystuchalk
Partner - Creator II
Partner - Creator II
Author

Thanks! I'm already solved this and posted solution, bou it still on moderation

robert_mika
Master III
Master III

Great good for you.