topic Re: Star Modelisation in QlikView

Star Modelisation

Tue, 25 Feb 2014 12:38:39 GMT

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

I Laod Two tables

My first table

Nominatif :

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 — Tue, 25 Feb 2014 12:48:22 GMT

Ben

Does the attached qvw give you food for thought ?

Best Regards, Bill

Tue, 25 Feb 2014 12:56:00 GMT

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 — Tue, 25 Feb 2014 13:03:34 GMT

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

Tue, 25 Feb 2014 13:09:24 GMT

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

Ps : excuse my bad english