1 Reply Latest reply: Mar 12, 2013 11:10 AM by Steve Dark RSS

    Making Field Names one field

      Hi, i have a excel sheet which i want to load into qlikview to create some charts and pivot tables.

       

      One problem i have is that i have each Month as a field its self with data in. This is fine for the pivot tables, but when i want to create a graph i want the date fields to be the axis but they are seperate fields.

       

      Here is what the excel spreadsheet looks like:

       

      ResourceProjectSegment%
      Deployed
      Target
      Project
      Start
      Project
      End
      Sept 12Oct 12Nov 12Dec 12Jan 13Feb 13Mar 13Apr 13May 13Jun 13Jul 13Aug 13Sep 13
      1AF2001/03/201231/03/201320202020202020202020202020
      1GF3001/08/201230/09/2012
      1LF2001/03/201230/06/2012
      1ZF2023/03/201220/07/2012
      1YF3014/07/201210/12/2012
      1XF2023/03/201205/06/2012
      1TF1001/06/201231/08/2012
      1NF3001/10/201231/10/2012
      1OF4014/07/201230/09/2012
      1MF5001/05/201231/05/201237
      1QF2001/04/201230/10/2012333320
      1PF5015/08/201230/11/2012
      1SF3001/06/201230/06/2012
      1VF1301/06/201231/10/2012 13
      1DF1001/06/201230/09/201210
      1KF7020/09/201231/03/2013 306035808080
      1CN/AN/AN/AN/A 45
      2AF2001/03/201231/03/201320202020202020
      2EF4001/03/201231/05/20120000000
      2HF1001/04/201230/10/2012301000000
      2ZF7523/03/201220/07/201210101010101010
      2YF3514/07/201210/12/201210304020000
      2XF2023/03/201205/06/20120000000
      2PF5015/08/201230/11/201230303050505050
      2ABF3001/07/201231/07/2012000020200
      3AF2001/03/201231/03/201320202020202020
      3IF4001/09/201228/02/2013
      3JF4001/04/201230/09/201220
      3LF2001/03/201230/06/2012
      3QF2001/04/201230/10/20123020
      3KF1220/09/201231/03/20123060
      4BE3030/03/201230/10/201210101010101010
      4FF1001/03/201231/03/20135555555
      4ZE3023/03/201220/07/201210101010101010
      4YE3014/07/201210/12/201230303030303030
      4XE3023/03/201205/06/20120000000
      4UE3005/05/201214/07/20125555555

       

       

       

      With the data like this i can easily create pivot tables with resource capicity by month as shown below:

       

      Resource Oct 12Nov 12Dec 12Jan 13Feb 13Mar 13Apr 13May 13Jun 13Jul 13Aug 13Sep 13 
      196100100100100100202020202020 
      210010010010010080000000 
      31002020202020000000 
      4807070707070000000 
      585100100959595000000

       

       

      however if i wanted to create a graph or be able to select a month how would i  be able to do this as they are current individual fields?

       

      Thanks

       

      Laura