topic Re: Change column headers to columns data in QlikView https://community.qlik.com/t5/QlikView/Change-column-headers-to-columns-data/m-p/117860#M766597 <HTML><HEAD></HEAD><BODY><P>Maybe</P><P></P><P>crosstable (Tables, GDP,5)</P><P>Load</P><P>[Country Name],</P><P>2014,</P><P>2015,</P><P>2016,</P><P>2017,</P><P>2014 as [Year 2014],</P><P>2015 as [Year 2014],</P><P>2016 as [Year 2014],</P><P>2017 as [Year 2014]</P><P>From....</P></BODY></HTML> Fri, 06 Jul 2018 15:56:33 GMT MK9885 2018-07-06T15:56:33Z Change column headers to columns data https://community.qlik.com/t5/QlikView/Change-column-headers-to-columns-data/m-p/117857#M766594 <HTML><HEAD></HEAD><BODY><P>Hi How do i change my data to as such</P><P></P><P>Country|Year|GDP</P><P>Peru|2014|xxx</P><P>Peru|2015|xxx</P><P></P><P>It is currently like this:</P><P><IMG __jive_id="207162" alt="Screen Shot 2018-07-06 at 5.19.48 PM.png" class="jive-image image-1" src="/legacyfs/online/207162_Screen Shot 2018-07-06 at 5.19.48 PM.png" style="height: 257px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Change-column-headers-to-columns-data/m-p/117857#M766594 Anonymous 2020-11-25T16:16:04Z Re: Change column headers to columns data https://community.qlik.com/t5/QlikView/Change-column-headers-to-columns-data/m-p/117858#M766595 <HTML><HEAD></HEAD><BODY><P>hello</P><P>you can try to use crosstable()</P><P>see "Working with cross tables" in qlik documentation</P></BODY></HTML> Fri, 06 Jul 2018 15:40:11 GMT https://community.qlik.com/t5/QlikView/Change-column-headers-to-columns-data/m-p/117858#M766595 olivierrobin 2018-07-06T15:40:11Z Re: Change column headers to columns data https://community.qlik.com/t5/QlikView/Change-column-headers-to-columns-data/m-p/117859#M766596 <HTML><HEAD></HEAD><BODY><P>for example :</P><P></P><P></P><P></P><P>t:</P><P>load * inline [</P><P>country,2014,2015,2016</P><P>a,4,5,6</P><P>b,7,8,9</P><P>];</P><P></P><P></P><P>t2:</P><P></P><P>CrossTable(year,sales,1) load * resident t;</P><P>drop table t;</P></BODY></HTML> Fri, 06 Jul 2018 15:55:02 GMT https://community.qlik.com/t5/QlikView/Change-column-headers-to-columns-data/m-p/117859#M766596 olivierrobin 2018-07-06T15:55:02Z Re: Change column headers to columns data https://community.qlik.com/t5/QlikView/Change-column-headers-to-columns-data/m-p/117860#M766597 <HTML><HEAD></HEAD><BODY><P>Maybe</P><P></P><P>crosstable (Tables, GDP,5)</P><P>Load</P><P>[Country Name],</P><P>2014,</P><P>2015,</P><P>2016,</P><P>2017,</P><P>2014 as [Year 2014],</P><P>2015 as [Year 2014],</P><P>2016 as [Year 2014],</P><P>2017 as [Year 2014]</P><P>From....</P></BODY></HTML> Fri, 06 Jul 2018 15:56:33 GMT https://community.qlik.com/t5/QlikView/Change-column-headers-to-columns-data/m-p/117860#M766597 MK9885 2018-07-06T15:56:33Z