https://community.qlik.com/t5/QlikView/CrossTable-with-multiple-columns/m-p/1663586#M729738 <P>HI All,</P><P>Could someone help to load&nbsp; below cross table data into qlikview</P><TABLE><TBODY><TR><TD>Case Number</TD><TD>Region</TD><TD><STRONG>Value1</STRONG></TD><TD><STRONG>Value2</STRONG></TD><TD>Closed Date</TD><TD>Opened Date</TD><TD><STRONG>30-08-2018</STRONG></TD><TD><STRONG>31-10-2018</STRONG></TD><TD><STRONG>30-09-2018</STRONG></TD></TR><TR><TD>1234</TD><TD>North</TD><TD>1</TD><TD>1</TD><TD>30-08-2018</TD><TD>30-08-2018</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>1243</TD><TD>North</TD><TD>0</TD><TD>1</TD><TD>30-09-2018</TD><TD>30-09-2018</TD><TD>0</TD><TD>1</TD><TD>0</TD></TR><TR><TD>1245</TD><TD>South</TD><TD>1</TD><TD>0</TD><TD>31-10-2018</TD><TD>31-10-2018</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>1254</TD><TD>South</TD><TD>1</TD><TD>1</TD><TD>30-08-2018</TD><TD>30-08-2018</TD><TD>0</TD><TD>1</TD><TD>1</TD></TR><TR><TD>1123</TD><TD>East</TD><TD>0</TD><TD>0</TD><TD>30-09-2018</TD><TD>31-10-2018</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>1232</TD><TD>West</TD><TD>0</TD><TD>1</TD><TD>31-10-2018</TD><TD>31-10-2018</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks in advance</P> Sat, 16 Nov 2024 19:20:47 GMT priya945 2024-11-16T19:20:47Z https://community.qlik.com/t5/QlikView/CrossTable-with-multiple-columns/m-p/1663586#M729738 <P>HI All,</P><P>Could someone help to load&nbsp; below cross table data into qlikview</P><TABLE><TBODY><TR><TD>Case Number</TD><TD>Region</TD><TD><STRONG>Value1</STRONG></TD><TD><STRONG>Value2</STRONG></TD><TD>Closed Date</TD><TD>Opened Date</TD><TD><STRONG>30-08-2018</STRONG></TD><TD><STRONG>31-10-2018</STRONG></TD><TD><STRONG>30-09-2018</STRONG></TD></TR><TR><TD>1234</TD><TD>North</TD><TD>1</TD><TD>1</TD><TD>30-08-2018</TD><TD>30-08-2018</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>1243</TD><TD>North</TD><TD>0</TD><TD>1</TD><TD>30-09-2018</TD><TD>30-09-2018</TD><TD>0</TD><TD>1</TD><TD>0</TD></TR><TR><TD>1245</TD><TD>South</TD><TD>1</TD><TD>0</TD><TD>31-10-2018</TD><TD>31-10-2018</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>1254</TD><TD>South</TD><TD>1</TD><TD>1</TD><TD>30-08-2018</TD><TD>30-08-2018</TD><TD>0</TD><TD>1</TD><TD>1</TD></TR><TR><TD>1123</TD><TD>East</TD><TD>0</TD><TD>0</TD><TD>30-09-2018</TD><TD>31-10-2018</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>1232</TD><TD>West</TD><TD>0</TD><TD>1</TD><TD>31-10-2018</TD><TD>31-10-2018</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks in advance</P> Sat, 16 Nov 2024 19:20:47 GMT https://community.qlik.com/t5/QlikView/CrossTable-with-multiple-columns/m-p/1663586#M729738 priya945 2024-11-16T19:20:47Z https://community.qlik.com/t5/QlikView/CrossTable-with-multiple-columns/m-p/1672708#M729739 <P>Priya, have a look at the following Design Blog post, believe this should likely help you get the job done:</P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/The-Crosstable-Load/ba-p/1468083" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/The-Crosstable-Load/ba-p/1468083</A></P> <P>Regards,<BR />Brett</P> Wed, 05 Feb 2020 21:18:14 GMT https://community.qlik.com/t5/QlikView/CrossTable-with-multiple-columns/m-p/1672708#M729739 Brett_Bleess 2020-02-05T21:18:14Z