topic Convert time-across data to time-down in QlikView https://community.qlik.com/t5/QlikView/Convert-time-across-data-to-time-down/m-p/239919#M90485 <HTML><HEAD></HEAD><BODY><P>Kevin</P><P>Use a crosstable load. This is an option with the table files wizard on the final page of the wizard.</P><P>You should land up with something like:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />CrossTable(Month, Volume)<BR />LOAD [CustID],<BR /> [July 09],<BR /> [Aug 09],<BR /> [Sep 09],<BR /> [Oct 09],<BR /> [Nov 09],<BR /> [Dec 09],<BR /> [Jan 10],<BR /> [Feb 10],<BR /> [Mar 10],<BR /> [April 10],<BR /> [May 10],<BR /> [Jun 10]<BR />FROM<BR />tmpStore.txt....<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P>This script produces a table with a columns: CustID, Month, Volume - which is what you are looking for, I think.</P><P>Jonathan</P></BODY></HTML> Mon, 02 Aug 2010 15:24:51 GMT jonathandienst 2010-08-02T15:24:51Z Convert time-across data to time-down https://community.qlik.com/t5/QlikView/Convert-time-across-data-to-time-down/m-p/239918#M90484 <HTML><HEAD></HEAD><BODY><P>Customer is providing source data where the amounts are separated by month in columns. For example, I have a column for Jan-09, one for Feb-09, and so on. When I load the data, I'd like to convert all of the amount columns into a single column and create a "Period" column indicating the period of the record (e.g. Jan-09, Feb-09, etc.). Thoughts?</P><P>Kevin</P></BODY></HTML> Mon, 02 Aug 2010 15:02:26 GMT https://community.qlik.com/t5/QlikView/Convert-time-across-data-to-time-down/m-p/239918#M90484 2010-08-02T15:02:26Z Convert time-across data to time-down https://community.qlik.com/t5/QlikView/Convert-time-across-data-to-time-down/m-p/239919#M90485 <HTML><HEAD></HEAD><BODY><P>Kevin</P><P>Use a crosstable load. This is an option with the table files wizard on the final page of the wizard.</P><P>You should land up with something like:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />CrossTable(Month, Volume)<BR />LOAD [CustID],<BR /> [July 09],<BR /> [Aug 09],<BR /> [Sep 09],<BR /> [Oct 09],<BR /> [Nov 09],<BR /> [Dec 09],<BR /> [Jan 10],<BR /> [Feb 10],<BR /> [Mar 10],<BR /> [April 10],<BR /> [May 10],<BR /> [Jun 10]<BR />FROM<BR />tmpStore.txt....<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P>This script produces a table with a columns: CustID, Month, Volume - which is what you are looking for, I think.</P><P>Jonathan</P></BODY></HTML> Mon, 02 Aug 2010 15:24:51 GMT https://community.qlik.com/t5/QlikView/Convert-time-across-data-to-time-down/m-p/239919#M90485 jonathandienst 2010-08-02T15:24:51Z