Pivot-graph

[Anonymous]

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

[JonnyPoole]

What is the unique identifer of a person in this data model ? 

[Anonymous]

Ni number

[JonnyPoole]

Ok. I thought that was going to be 'account' as in 'account number.  Which field or combination of fields uniquely identifies ' account' ?

[Anonymous]

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.