Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

pzwonford
New Contributor II

Pivot-graph

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

Tags (1)
4 Replies
Employee
Employee

Re: Pivot-graph

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

pzwonford
New Contributor II

Re: Pivot-graph

Ni number

Employee
Employee

Re: Pivot-graph

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

pzwonford
New Contributor II

Re: Pivot-graph

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.

Community Browser