4 Replies Latest reply: Oct 15, 2014 3:56 AM by Paul Wonford RSS

    Pivot-graph

    Paul Wonford

      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