I won't reply in your preferred language, as this is a general forum where the imposed language is English. I hope you'll understand.
As far as I can see, you have three facts tables. One table OBJECTIF contains Agency targets (without a period indicator), one table DONNEES_PRJ has Agency/Department/Portfolio aggregated data and one table DONNEES_LOGIX contains Customer Sales (most probably aggregated by Year). There are a few "issues" with this data set:
- Period information is missing in most of them
- The data is often already aggregated, which restricts your mobility in QlikView.
- The three facts tables will compete with each other for dimension values. If you select on as dimension value master, you will have one facts table that filters the others.
There is one immediate solution: replace the synthetic key with a real link table
- Convert all double key fields into single key fields by creating a key composed of a concatenation of key values.
- Create a link table with all possible dimension values and their corresponding composed key values
- Drop all dimension fields (like Agence, Vendeur & Département) from all facts tables, as they will now reside in the link table
but the better approach is to go back to the transactional data (except for table OBJECTIF) and do the aggregations yourself.
Best,
Peter
