topic Re: Load dynamically Month column in QlikView https://community.qlik.com/t5/QlikView/Load-dynamically-Month-column/m-p/1112233#M633889 <HTML><HEAD></HEAD><BODY><P>May be use a crosstable load here:</P><P><A href="https://community.qlik.com/qlik-blogpost/3628">The Crosstable Load</A></P></BODY></HTML> Thu, 07 Jul 2016 16:05:29 GMT sunny_talwar 2016-07-07T16:05:29Z Load dynamically Month column https://community.qlik.com/t5/QlikView/Load-dynamically-Month-column/m-p/1112232#M633888 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>I need help to implement this feature in my script:</P><P>I have an excel file with the last 6 month </P><TABLE border="1" class="jiveBorder" height="74" style="border: 1px solid #000000; width: 681px; height: 49px;" width="679"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Jan 16</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG> Feb 16</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Mar 16</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Apr 16</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">May 16</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Jun 16</STRONG></TH></TR><TR><TD style="padding: 2px;">value</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">value</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">value</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">value</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">value</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">value</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">value</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">value</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">value</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">value</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">value</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">value</SPAN></TD></TR></TBODY></TABLE><P></P><P>how con I upload this automatically in my sheet without modify the structure of the table?</P><P></P><P>My idea was to have a pivot table with all month for 5 years and display only them specified into the excel file, but if I try this idea i receive an upload error.</P><P></P><P>Anyone has some idea on how to resolve my problem?</P><P>Other ideas are accepted of course.</P><P></P><P>Thanks </P></BODY></HTML> Thu, 07 Jul 2016 15:41:57 GMT https://community.qlik.com/t5/QlikView/Load-dynamically-Month-column/m-p/1112232#M633888 2016-07-07T15:41:57Z Re: Load dynamically Month column https://community.qlik.com/t5/QlikView/Load-dynamically-Month-column/m-p/1112233#M633889 <HTML><HEAD></HEAD><BODY><P>May be use a crosstable load here:</P><P><A href="https://community.qlik.com/qlik-blogpost/3628">The Crosstable Load</A></P></BODY></HTML> Thu, 07 Jul 2016 16:05:29 GMT https://community.qlik.com/t5/QlikView/Load-dynamically-Month-column/m-p/1112233#M633889 sunny_talwar 2016-07-07T16:05:29Z Re: Load dynamically Month column https://community.qlik.com/t5/QlikView/Load-dynamically-Month-column/m-p/1112234#M633890 <HTML><HEAD></HEAD><BODY><P>Please post a small sample of your excel file, the script and the error message.</P><P></P><P>thanks</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Thu, 07 Jul 2016 22:50:04 GMT https://community.qlik.com/t5/QlikView/Load-dynamically-Month-column/m-p/1112234#M633890 MarcoWedel 2016-07-07T22:50:04Z