topic Re: Cross Table in Qlik Sense in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Cross-Table-in-Qlik-Sense/m-p/1942646#M10891 <P>Hello,</P> <P>&nbsp;</P> <P><A href="https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/LoadData/work-with-cross-tables.htm" target="_blank">Working with crosstables in the data load script ‒ Qlik Sense on Windows</A></P> Mon, 13 Jun 2022 07:18:20 GMT eronevil 2022-06-13T07:18:20Z Cross Table in Qlik Sense https://community.qlik.com/t5/Connectivity-Data-Prep/Cross-Table-in-Qlik-Sense/m-p/1920620#M10589 <P>Dear All,</P> <P>could you please guide me , how this can be unpivoted(Qualifying columns-&nbsp; Country, region, Task ID).</P> <P>&nbsp;</P> <P>&nbsp;</P> <TABLE width="1240"> <TBODY> <TR> <TD width="64">&nbsp;</TD> <TD width="64">&nbsp;</TD> <TD width="64">&nbsp;</TD> <TD colspan="4" width="425">Jan 2022</TD> <TD colspan="4" width="394">Feb 2022</TD> <TD colspan="4" width="229">Mar 2022</TD> </TR> <TR> <TD>Country</TD> <TD>Region</TD> <TD>Task ID</TD> <TD>Received date</TD> <TD width="64">Start Date</TD> <TD width="115">End Date</TD> <TD>Status/Comments</TD> <TD>Received date</TD> <TD width="75">Start Date</TD> <TD width="83">End Date</TD> <TD>Status/Comments</TD> <TD>Received date</TD> <TD width="65">Start Date</TD> <TD width="64">End Date</TD> <TD>Status/Comments</TD> </TR> <TR> <TD>UK</TD> <TD>Europe</TD> <TD>A1</TD> <TD>5-Jan-22</TD> <TD>5-Jan-22</TD> <TD>8-Jan-22</TD> <TD>Success</TD> <TD>5-Feb-22</TD> <TD>5-Feb-22</TD> <TD>8-Feb-22</TD> <TD>Success</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>Ireland</TD> <TD>Europe</TD> <TD>A2</TD> <TD>9-Jan-22</TD> <TD>9-Jan-22</TD> <TD>9-Jan-22</TD> <TD>Success</TD> <TD>9-Feb-22</TD> <TD>9-Feb-22</TD> <TD>9-Feb-22</TD> <TD>Success</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>USA</TD> <TD>NA</TD> <TD>A3</TD> <TD>5-Jan-22</TD> <TD>9-Jan-22</TD> <TD>10-Jan-22</TD> <TD>Success</TD> <TD>5-Feb-22</TD> <TD>9-Feb-22</TD> <TD>12-Feb-22</TD> <TD>Success</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> </TBODY> </TABLE> Wed, 20 Apr 2022 18:48:04 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Cross-Table-in-Qlik-Sense/m-p/1920620#M10589 SayD 2022-04-20T18:48:04Z Re: Cross Table in Qlik Sense https://community.qlik.com/t5/Connectivity-Data-Prep/Cross-Table-in-Qlik-Sense/m-p/1942646#M10891 <P>Hello,</P> <P>&nbsp;</P> <P><A href="https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/LoadData/work-with-cross-tables.htm" target="_blank">Working with crosstables in the data load script ‒ Qlik Sense on Windows</A></P> Mon, 13 Jun 2022 07:18:20 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Cross-Table-in-Qlik-Sense/m-p/1942646#M10891 eronevil 2022-06-13T07:18:20Z