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


    Paul Wonford

      Hi guys,

      I have two tables:


      NI number,
      Saving amount,
      Close date



      NI number,
      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