Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Star Modelisation

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

I Laod Two  tables

My first table

Nominatif :

NameCCNUnits
Jonathan COHEN 96242000
Jonathan COHEN 240922001
Xavier Fontanet400412
Xavier Fontanet4004456
Xavier Fontanet6423299
Xavier Fontanet21225000

Pivot

NameCCN1CCN2CCN3
Jonathan COHEN962424092
Xavier Fontanet400464232122

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

Please See attached

4 Replies
Anonymous
Not applicable
Author

Ben

Does the attached qvw give you food for thought ?

Best Regards,     Bill

Not applicable
Author

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
Not applicable
Author

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

Not applicable
Author

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

Ps : excuse my bad english