Star Modelisation

[#1]

Hey Evrebody , I a begenneer in qlikview and i have a problem with my facts table

I Laod Two  tables

My first table

Nominatif :

Name	CCN	Units
Jonathan COHEN	9624	2000
Jonathan COHEN	24092	2001
Xavier Fontanet	4004	12
Xavier Fontanet	4004	456
Xavier Fontanet	6423	299
Xavier Fontanet	2122	5000

Pivot

Name	CCN1	CCN2	CCN3
Jonathan COHEN	9624	24092
Xavier Fontanet	4004	6423	2122

For each CCN number  I want to display the number of units  all in keeping my modélisation Star

Please See attached

[Anonymous]

Ben

Does the attached qvw give you food for thought ?

Best Regards,     Bill

[#3]

Thank U Bill

I do not understand why do you put count(Nom)  , it does not serve me much

for example  when i clic in Xavier Fontanet I want to show all his CCN and Units that corresponding.

Ben

[Anonymous]

Ben

Being an English speaker I guessed at what your field names meant, and obviously guessed wrong.

Hopefully somebody with better language skills (French?) than I will be able to assist you.

Best Regards,     Bill

[#5]

Well if you did not understand I could explain you , which  fields you did not understand

Ps : excuse my bad english