topic Double Cross Table in QlikView https://community.qlik.com/t5/QlikView/Double-Cross-Table/m-p/214383#M67930 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I'm trying to handle a cross table with several levels, it looks like this:</P><P></P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-4083_sourceID:4083" /></P><P></P><P>Any ideas?</P><P>Thanks!</P></BODY></HTML> Wed, 13 Apr 2011 21:02:41 GMT villafuerte 2011-04-13T21:02:41Z Double Cross Table https://community.qlik.com/t5/QlikView/Double-Cross-Table/m-p/214383#M67930 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I'm trying to handle a cross table with several levels, it looks like this:</P><P></P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-4083_sourceID:4083" /></P><P></P><P>Any ideas?</P><P>Thanks!</P></BODY></HTML> Wed, 13 Apr 2011 21:02:41 GMT https://community.qlik.com/t5/QlikView/Double-Cross-Table/m-p/214383#M67930 villafuerte 2011-04-13T21:02:41Z Double Cross Table https://community.qlik.com/t5/QlikView/Double-Cross-Table/m-p/214384#M67931 <HTML><HEAD></HEAD><BODY><P>Well, unfortunately, CROSSTABLE load doesn't hand;e this situation "out of the box" ...</P><P></P><P>So, if your data structure is fairly static, You can separate it into 2 CROSSTABLE loads - first, load only Budgets, and then, load only Actuals.</P><P>Otherwise, you need to read each column separately and identify separately what belongs to what - quite messy, I have to say...</P></BODY></HTML> Wed, 13 Apr 2011 22:10:56 GMT https://community.qlik.com/t5/QlikView/Double-Cross-Table/m-p/214384#M67931 Oleg_Troyansky 2011-04-13T22:10:56Z