topic Re: Pivot-graph in QlikView

Pivot-graph

Anonymous — Tue, 14 Oct 2014 15:50:30 GMT

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

Re: Pivot-graph

JonnyPoole — Tue, 14 Oct 2014 15:53:29 GMT

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

Re: Pivot-graph

Anonymous — Tue, 14 Oct 2014 15:57:10 GMT

Ni number

Re: Pivot-graph

JonnyPoole — Tue, 14 Oct 2014 16:05:37 GMT

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

Re: Pivot-graph

Anonymous — Wed, 15 Oct 2014 07:56:41 GMT

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.