Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Making Field Names one field

Hi Laura,

This is a relatively simple CROSSTABLE, if you search on that statement you should find plenty of examples.  The only thing that may take a little more effort is getting the date to behave correctly.  I would probably do the crosstable into a temporary table and then manipulate the date in a RESIDENT load.

Hope that points you in the correct direction.

- Steve

http://www.quickintelligence.co.uk/

1 Reply
MVP
MVP

Re: Making Field Names one field

Hi Laura,

This is a relatively simple CROSSTABLE, if you search on that statement you should find plenty of examples.  The only thing that may take a little more effort is getting the date to behave correctly.  I would probably do the crosstable into a temporary table and then manipulate the date in a RESIDENT load.

Hope that points you in the correct direction.

- Steve

http://www.quickintelligence.co.uk/

Community Browser