topic Re: Excel, scaling columns load statement in QlikView https://community.qlik.com/t5/QlikView/Excel-scaling-columns-load-statement/m-p/913586#M985464 <HTML><HEAD></HEAD><BODY><P>I'm sorry I don't understand, Gysbert approach is correct, here are the results</P><P></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" height="264" style="width: 335px; height: 271px;" width="335"><TBODY><TR><TD class="xl64" height="17" width="50">RowNo</TD><TD class="xl64" style="border-left: none;" width="192">Classification</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">1</TD><TD class="xl66" style="border-top: none; border-left: none;">Administration</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">2</TD><TD class="xl66" style="border-top: none; border-left: none;">Application Support by Third Party</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">3</TD><TD class="xl66" style="border-top: none; border-left: none;">Pre-approved</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">4</TD><TD class="xl66" style="border-top: none; border-left: none;">Automated Alert</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">5</TD><TD class="xl66" style="border-top: none; border-left: none;">Automated Alert</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">6</TD><TD class="xl66" style="border-top: none; border-left: none;">Automated Alert</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">7</TD><TD class="xl66" style="border-top: none; border-left: none;">Automated Alert</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">8</TD><TD class="xl66" style="border-top: none; border-left: none;">Data Base Services</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">9</TD><TD class="xl66" style="border-top: none; border-left: none;">Automated Alert</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">10</TD><TD class="xl66" style="border-top: none; border-left: none;">Configuration</TD></TR></TBODY></TABLE><P></P><P>Isn't this what you need?</P></BODY></HTML> Thu, 06 Aug 2015 13:30:35 GMT maximiliano_vel 2015-08-06T13:30:35Z Excel, scaling columns load statement https://community.qlik.com/t5/QlikView/Excel-scaling-columns-load-statement/m-p/913584#M985462 <HTML><HEAD></HEAD><BODY><P>Goodday clever QlikView peoples,</P><P></P><P>Here is one for you, refer to Excel extract below:</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 892px;"><TBODY><TR><TD class="xl65" height="20" width="64"><STRONG style="color: #3366ff;">RowNo</STRONG></TD><TD width="193"><STRONG>Classification1</STRONG></TD><TD width="196"><STRONG>Classification2</STRONG></TD><TD width="223"><STRONG>Classification3</STRONG></TD><TD width="123"><STRONG>Classification4</STRONG></TD><TD width="93"><STRONG>Classification5</STRONG></TD></TR><TR><TD class="xl65" height="20"><STRONG style="color: #3366ff;">1</STRONG></TD><TD>Oracle Database Services</TD><TD><STRONG style="color: #ff9900;">Administration</STRONG></TD><TD></TD></TR><TR><TD class="xl65" height="20"><STRONG style="color: #3366ff;">2</STRONG></TD><TD>Business Application Services</TD><TD>Support</TD><TD><STRONG style="color: #ff9900;">Application Support by Third Party</STRONG></TD><TD></TD></TR><TR><TD class="xl65" height="20"><STRONG style="color: #3366ff;">3</STRONG></TD><TD>Service Support Services</TD><TD>Change Management Services</TD><TD>Business Application Services</TD><TD>Standard Change</TD><TD><SPAN style="color: #ff9900;"><STRONG>Pre-approved</STRONG></SPAN></TD></TR><TR><TD class="xl65" height="20"><STRONG style="color: #3366ff;">4</STRONG></TD><TD>SQL Database Services</TD><TD><SPAN style="color: #ff9900;">Automated Alert</SPAN></TD><TD></TD></TR><TR><TD class="xl65" height="20"><STRONG style="color: #3366ff;">5</STRONG></TD><TD>SQL Database Services</TD><TD>Automated Alert</TD><TD></TD></TR><TR><TD class="xl65" height="20"><STRONG style="color: #3366ff;">6</STRONG></TD><TD>SQL Database Services</TD><TD>Automated Alert</TD><TD></TD></TR><TR><TD class="xl65" height="20"><STRONG style="color: #3366ff;">7</STRONG></TD><TD>SQL Database Services</TD><TD>Automated Alert</TD><TD></TD></TR><TR><TD class="xl65" height="20"><STRONG style="color: #3366ff;">8</STRONG></TD><TD>Monitoring Services</TD><TD>Automated Alert Reaction</TD><TD>Server Services</TD><TD>Data Base Services</TD><TD></TD></TR><TR><TD class="xl65" height="20"><STRONG style="color: #3366ff;">9</STRONG></TD><TD>SQL Database Services</TD><TD>Automated Alert</TD><TD></TD></TR><TR><TD class="xl65" height="20"><STRONG style="color: #3366ff;">10</STRONG></TD><TD>SQL Database Services</TD><TD>Database</TD><TD>Configuration</TD><TD></TD></TR></TBODY></TABLE><P></P><P>I'm looking to get the value where the classification ends. I.E</P><P><SPAN style="color: #3366ff;"><STRONG>RowNo 1</STRONG></SPAN> final classification was <STRONG style=": ; color: #ff9900;">Administration</STRONG></P><P><SPAN style="font-size: 13.3333330154419px;"><SPAN style="color: #3366ff;"><STRONG>RowNo 2</STRONG></SPAN> <SPAN style="font-size: 13.3333330154419px;">final classification was </SPAN><SPAN style="font-size: 13.3333330154419px;"><STRONG style="color: #ff9900;">Application Support by Third Party</STRONG></SPAN></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;"><STRONG style="color: #3366ff;">RowNo 3</STRONG> <SPAN style="font-size: 13.3333330154419px;">final classification was </SPAN><SPAN style="font-size: 13.3333330154419px;"><STRONG style="color: #ff9900;">Pre-approved</STRONG></SPAN></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;"><STRONG style="color: #3366ff;">RowNo 4 </STRONG><SPAN style="font-size: 13.3333330154419px;">final classification was </SPAN><SPAN style="font-size: 13.3333330154419px;"><STRONG style="color: #ff9900;">Automated Alert</STRONG></SPAN></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">etc,etc</SPAN></P><P></P><P>Your load statement would be highly appreciated</P></BODY></HTML> Thu, 06 Aug 2015 11:32:35 GMT https://community.qlik.com/t5/QlikView/Excel-scaling-columns-load-statement/m-p/913584#M985462 2015-08-06T11:32:35Z Re: Excel, scaling columns load statement https://community.qlik.com/t5/QlikView/Excel-scaling-columns-load-statement/m-p/913585#M985463 <HTML><HEAD></HEAD><BODY><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; RowNo,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; If(Len(Trim(Classification5)),<SPAN style="font-size: 13.3333330154419px;">Classification5, </SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(<SPAN style="font-size: 13.3333330154419px;">Len(Trim(Classification4)),</SPAN><SPAN style="font-size: 13.3333330154419px;">Classification4, </SPAN></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(<SPAN style="font-size: 13.3333330154419px;">Len(Trim(Classification3)),</SPAN><SPAN style="font-size: 13.3333330154419px;">Classification3, </SPAN></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;"><SPAN style="font-size: 13.3333330154419px;"><SPAN style="font-size: 13.3333330154419px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(<SPAN style="font-size: 13.3333330154419px;">Len(Trim(Classification2)),</SPAN><SPAN style="font-size: 13.3333330154419px;">Classification2,<SPAN style="font-size: 13.3333330154419px;">Classification1</SPAN> </SPAN>) </SPAN>) </SPAN>) </SPAN>) as Classification</P><P>FROM ...source... ;</P></BODY></HTML> Thu, 06 Aug 2015 11:36:03 GMT https://community.qlik.com/t5/QlikView/Excel-scaling-columns-load-statement/m-p/913585#M985463 Gysbert_Wassenaar 2015-08-06T11:36:03Z Re: Excel, scaling columns load statement https://community.qlik.com/t5/QlikView/Excel-scaling-columns-load-statement/m-p/913586#M985464 <HTML><HEAD></HEAD><BODY><P>I'm sorry I don't understand, Gysbert approach is correct, here are the results</P><P></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" height="264" style="width: 335px; height: 271px;" width="335"><TBODY><TR><TD class="xl64" height="17" width="50">RowNo</TD><TD class="xl64" style="border-left: none;" width="192">Classification</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">1</TD><TD class="xl66" style="border-top: none; border-left: none;">Administration</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">2</TD><TD class="xl66" style="border-top: none; border-left: none;">Application Support by Third Party</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">3</TD><TD class="xl66" style="border-top: none; border-left: none;">Pre-approved</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">4</TD><TD class="xl66" style="border-top: none; border-left: none;">Automated Alert</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">5</TD><TD class="xl66" style="border-top: none; border-left: none;">Automated Alert</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">6</TD><TD class="xl66" style="border-top: none; border-left: none;">Automated Alert</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">7</TD><TD class="xl66" style="border-top: none; border-left: none;">Automated Alert</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">8</TD><TD class="xl66" style="border-top: none; border-left: none;">Data Base Services</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">9</TD><TD class="xl66" style="border-top: none; border-left: none;">Automated Alert</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">10</TD><TD class="xl66" style="border-top: none; border-left: none;">Configuration</TD></TR></TBODY></TABLE><P></P><P>Isn't this what you need?</P></BODY></HTML> Thu, 06 Aug 2015 13:30:35 GMT https://community.qlik.com/t5/QlikView/Excel-scaling-columns-load-statement/m-p/913586#M985464 maximiliano_vel 2015-08-06T13:30:35Z