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: 
achraf
Contributor II
Contributor II

Multiple foreign keys between dimension table date and fact table

hi there,
i am a beginner in qlik sense, and i found a problem with association between dimension table date and fact table (MEL).

Annotation 2019-05-19 012402.png

could you explain the best way to resolve the problem.

Anyone please help.
Thanks,

Labels (2)
9 Replies
ajaykakkar93
Specialist III
Specialist III

Hi,

Can you attach the image because it cannot be viewed, may be I will be able to Lelo you if you provide us with a sample data. Similar structure as your case.

Please mark the correct replies as Solution. Regards, ARK
Profile| GitHub|YouTube|Extension|Mashup|Qlik API|Qlik NPrinting

achraf
Contributor II
Contributor II
Author

This is the complete picture

Annotation 2019-05-19 022814.png

thank you for reply

ajaykakkar93
Specialist III
Specialist III

Attach the image do not embed it it is not showing..

Please mark the correct replies as Solution. Regards, ARK
Profile| GitHub|YouTube|Extension|Mashup|Qlik API|Qlik NPrinting

achraf
Contributor II
Contributor II
Author

i'm sorry but i don't understand you, the image is showing for me, and the same in other devices
ajaykakkar93
Specialist III
Specialist III

?

Please mark the correct replies as Solution. Regards, ARK
Profile| GitHub|YouTube|Extension|Mashup|Qlik API|Qlik NPrinting

achraf
Contributor II
Contributor II
Author

i'm sorry for disturbance
but try this

https://imgur.com/apSalgI

ajaykakkar93
Specialist III
Specialist III

I think U can join date with the fact, and using unlink date you an filter your dates through. you can  try this & wait some more replies.. I want to know what else can be done ..

Please mark the correct replies as Solution. Regards, ARK
Profile| GitHub|YouTube|Extension|Mashup|Qlik API|Qlik NPrinting

achraf
Contributor II
Contributor II
Author

thank you for reply, and i hope someone give me the answer
achraf
Contributor II
Contributor II
Author

up