Discussion Board for collaboration related to Creating Analytics for QlikView.
I have two tables:
NI number,Title,Saving amount,Close date
NI number,Title,Saving amount,
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 people0, 12, 23, 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 ?
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.