https://community.qlik.com/t5/QlikView/CROSSTABLE/m-p/1740635#M590582 <P>Please How do i choose random columns located at the end of the column list as the qualifiers field in a crosstable of about 2000 column..the columns i want to choose aren't at the beginning of the table.</P> Wed, 02 Sep 2020 12:50:10 GMT Xformation 2020-09-02T12:50:10Z https://community.qlik.com/t5/QlikView/CROSSTABLE/m-p/1740635#M590582 <P>Please How do i choose random columns located at the end of the column list as the qualifiers field in a crosstable of about 2000 column..the columns i want to choose aren't at the beginning of the table.</P> Wed, 02 Sep 2020 12:50:10 GMT https://community.qlik.com/t5/QlikView/CROSSTABLE/m-p/1740635#M590582 Xformation 2020-09-02T12:50:10Z https://community.qlik.com/t5/QlikView/CROSSTABLE/m-p/1740840#M590583 <P>You can reorder the load using a preceding load or a resident load before you add the crosstable function.</P> Wed, 02 Sep 2020 23:38:28 GMT https://community.qlik.com/t5/QlikView/CROSSTABLE/m-p/1740840#M590583 Lisa_P 2020-09-02T23:38:28Z https://community.qlik.com/t5/QlikView/CROSSTABLE/m-p/1744363#M590584 <P>Here is an additional Design Blog post regarding Preceding Load mentioned by Lisa for future visitors:</P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Preceding-Load/ba-p/1469534" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Preceding-Load/ba-p/1469534</A></P><P>Regards,<BR />Brett</P> Wed, 16 Sep 2020 15:01:34 GMT https://community.qlik.com/t5/QlikView/CROSSTABLE/m-p/1744363#M590584 Brett_Bleess 2020-09-16T15:01:34Z