Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have two tables:
Existing:
NI number,
Title,
Saving amount,
Close date
New:
NI number,
Title,
Saving amount,
Application date
I'm trying to put the data together to show a pivot graph of how many people have applied (from the new table) and how many existing (open) accounts they have. For example
No of existing accounts, no of people
0, 1
2, 2
3, 1
I've attached the qlikview files for you to have a look but i'm really stumped. I've also attached a copy of what I am trying to achieve in Excel so you can get an idea
What is the unique identifer of a person in this data model ?
Ni number
Ok. I thought that was going to be 'account' as in 'account number. Which field or combination of fields uniquely identifies ' account' ?
Apologies, it's a cut down version of the real thing. For every line in existing that's another account so i guess we could put account number in there if needs be.