Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Ben
Does the attached qvw give you food for thought ?
Best Regards, Bill
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
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
Well if you did not understand I could explain you , which fields you did not understand
Ps : excuse my bad english