topic Creating crosstable in QlikView https://community.qlik.com/t5/QlikView/Creating-crosstable/m-p/228558#M80584 <HTML><HEAD></HEAD><BODY><P>Thank you very much John.</P><P></P></BODY></HTML> Tue, 05 Oct 2010 21:52:50 GMT 2010-10-05T21:52:50Z Creating crosstable https://community.qlik.com/t5/QlikView/Creating-crosstable/m-p/228556#M80582 <HTML><HEAD></HEAD><BODY><P>Dear Experts:</P><P>I have a table of billing totals per month &amp; customer, like that:</P><P>CustomerID,BillingMonth,Amount</P><P>100;01;3000</P><P>100;02;5000</P><P>100;03;4000</P><P>101;01;3003</P><P>102;02;8004</P><P>103;03;403</P><P>I need to display the data as a crosstable (each month should be represented as a column):</P><P>CustomerID;01;02;03;04</P><P>It sounds like the opposite of the "crosstable" command.</P><P>there is is a way to do that without complicated macros?</P><P>Thanks,</P><P>Shlomo</P><P></P><P></P><P></P><P></P></BODY></HTML> Tue, 05 Oct 2010 21:46:22 GMT https://community.qlik.com/t5/QlikView/Creating-crosstable/m-p/228556#M80582 2010-10-05T21:46:22Z Creating crosstable https://community.qlik.com/t5/QlikView/Creating-crosstable/m-p/228557#M80583 <HTML><HEAD></HEAD><BODY><P>Just display it that way? Pivot table with CustomerID and BillingMonth as dimensions, drag BillingMonth to the top.</P><P>If you want to do it in your data structure itself, look into "generic load", which is the opposite of "crosstable load".</P></BODY></HTML> Tue, 05 Oct 2010 21:51:21 GMT https://community.qlik.com/t5/QlikView/Creating-crosstable/m-p/228557#M80583 johnw 2010-10-05T21:51:21Z Creating crosstable https://community.qlik.com/t5/QlikView/Creating-crosstable/m-p/228558#M80584 <HTML><HEAD></HEAD><BODY><P>Thank you very much John.</P><P></P></BODY></HTML> Tue, 05 Oct 2010 21:52:50 GMT https://community.qlik.com/t5/QlikView/Creating-crosstable/m-p/228558#M80584 2010-10-05T21:52:50Z