topic Re: Crosstable Concatenation in QlikView https://community.qlik.com/t5/QlikView/Crosstable-Concatenation/m-p/605639#M1118429 <HTML><HEAD></HEAD><BODY><P>thank you henric<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 05 Feb 2014 11:11:14 GMT 2014-02-05T11:11:14Z Crosstable Concatenation https://community.qlik.com/t5/QlikView/Crosstable-Concatenation/m-p/605635#M1118425 <HTML><HEAD></HEAD><BODY><P>Hi,&nbsp; Can anyone say how to concatenate the cross table?</P></BODY></HTML> Tue, 04 Feb 2014 14:10:00 GMT https://community.qlik.com/t5/QlikView/Crosstable-Concatenation/m-p/605635#M1118425 2014-02-04T14:10:00Z Re: Crosstable Concatenation https://community.qlik.com/t5/QlikView/Crosstable-Concatenation/m-p/605636#M1118426 <HTML><HEAD></HEAD><BODY><P>You need to do it in two steps. First concatenate the tables, then apply the Crosstable on the resulting table. E.g.</P><P></P><P>tmp:</P><P>Load * from Table1;</P><P>Load * from Table2;</P><P></P><P>Final:</P><P>Crosstable (...) Load * from tmp;</P><P></P><P>Drop table tmp;</P><P></P><P>HIC</P></BODY></HTML> Tue, 04 Feb 2014 14:19:01 GMT https://community.qlik.com/t5/QlikView/Crosstable-Concatenation/m-p/605636#M1118426 hic 2014-02-04T14:19:01Z Re: Crosstable Concatenation https://community.qlik.com/t5/QlikView/Crosstable-Concatenation/m-p/605637#M1118427 <HTML><HEAD></HEAD><BODY><P>Hi</P><P><A href="http://www.qlikfix.com/2010/12/09/merging-tables-concatenation/" title="http://www.qlikfix.com/2010/12/09/merging-tables-concatenation/">Merging tables: concatenation ยป The Qlik Fix! The Qlik Fix!</A></P><P>refer this site may be you will get the answer...</P></BODY></HTML> Wed, 05 Feb 2014 05:36:13 GMT https://community.qlik.com/t5/QlikView/Crosstable-Concatenation/m-p/605637#M1118427 arulsettu 2014-02-05T05:36:13Z Re: Crosstable Concatenation https://community.qlik.com/t5/QlikView/Crosstable-Concatenation/m-p/605638#M1118428 <HTML><HEAD></HEAD><BODY><P>hi</P><P>firstly concate both table and then get desired(merge) table.</P><P>then apply crosstable on this merge table.</P></BODY></HTML> Wed, 05 Feb 2014 05:58:28 GMT https://community.qlik.com/t5/QlikView/Crosstable-Concatenation/m-p/605638#M1118428 2014-02-05T05:58:28Z Re: Crosstable Concatenation https://community.qlik.com/t5/QlikView/Crosstable-Concatenation/m-p/605639#M1118429 <HTML><HEAD></HEAD><BODY><P>thank you henric<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 05 Feb 2014 11:11:14 GMT https://community.qlik.com/t5/QlikView/Crosstable-Concatenation/m-p/605639#M1118429 2014-02-05T11:11:14Z Re: Crosstable Concatenation https://community.qlik.com/t5/QlikView/Crosstable-Concatenation/m-p/605640#M1118430 <HTML><HEAD></HEAD><BODY><P>hi thanks for all</P></BODY></HTML> Wed, 05 Feb 2014 11:11:54 GMT https://community.qlik.com/t5/QlikView/Crosstable-Concatenation/m-p/605640#M1118430 2014-02-05T11:11:54Z