Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to establish a relation

I have this model and want to make a relation between Month filed in Table 3 with eYear field on Link Table. Since both of them are date fields. Right now if i select month value, rest of the charts were not showing any data even though they have common value.

I would like to know how these relations works in qlikview, is it same way like RDBMS?

Thanks for your help. 

4 Replies
eddysanchez
Partner - Creator
Partner - Creator

Table3 and LinkTable are connected by KEY3

You have problem in your data

when you have Month (Table3), you don't have eYear(LinkTable)

verify if you aren't losing the value of LeadExit ( [WIN 8 OS Updates]/ )

when you load in the LinkTable

Not applicable
Author

What do you mean by problem in data? I dont see losing the value of LeadExit. can you tell me why would you thinking of loosing data. I can see eYear in LinkTable. if I miss some thing, please let me know.

Not applicable
Author

Any help, why the relation is not working on above model.

Not applicable
Author

I appreciate your help. I got stuck on how to handle this scnerio in qlikview.