https://community.qlik.com/t5/QlikView/Columns-in-to-rows/m-p/175329#M43816 <HTML><HEAD></HEAD><BODY><P>You could load each column separately and then link between them, but I doubt if it's going to be faster than a crosstable load.</P><P>On the other hand, considering the nature of this data - just HOW MUCH data do you have? I don't think it should be too huge, and hence a degradation in performance must be caused by something else - maybe you are running into synthetic keys, or maybe you have a join with misspelled key names, that causes a Cartesian multiplication?</P><P>I can't buy into the premise of CROSSTABLE load on this data causing major performance problems by itself, - there must be something else...</P><P></P><DIV id="refHTML"></DIV></BODY></HTML> Wed, 19 Jan 2011 16:26:13 GMT Oleg_Troyansky 2011-01-19T16:26:13Z https://community.qlik.com/t5/QlikView/Columns-in-to-rows/m-p/175328#M43815 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>I have a table with working days of every month with the executives like this</P><P>Jan Feb Mar Apr Jun Jul</P><P>A 23 18 22 29 20 27</P><P>B 20 18 24 20 20 20</P><P></P><P>I need calculate the average clearence per day sum(clearence)/sum(working days). Since month names are as the columns how to calculate the sum(working days). If i select the specific month it should be diaplyed for the month, I tried using the cross table due to number of years there is degradation in performance. Is there any other way other than cross table.</P><P></P></BODY></HTML> Wed, 19 Jan 2011 14:02:08 GMT https://community.qlik.com/t5/QlikView/Columns-in-to-rows/m-p/175328#M43815 2011-01-19T14:02:08Z https://community.qlik.com/t5/QlikView/Columns-in-to-rows/m-p/175329#M43816 <HTML><HEAD></HEAD><BODY><P>You could load each column separately and then link between them, but I doubt if it's going to be faster than a crosstable load.</P><P>On the other hand, considering the nature of this data - just HOW MUCH data do you have? I don't think it should be too huge, and hence a degradation in performance must be caused by something else - maybe you are running into synthetic keys, or maybe you have a join with misspelled key names, that causes a Cartesian multiplication?</P><P>I can't buy into the premise of CROSSTABLE load on this data causing major performance problems by itself, - there must be something else...</P><P></P><DIV id="refHTML"></DIV></BODY></HTML> Wed, 19 Jan 2011 16:26:13 GMT https://community.qlik.com/t5/QlikView/Columns-in-to-rows/m-p/175329#M43816 Oleg_Troyansky 2011-01-19T16:26:13Z