topic Re: Coluna Calculada no Script in Brasil https://community.qlik.com/t5/Brasil/Coluna-Calculada-no-Script/m-p/1187924#M41812 <HTML><HEAD></HEAD><BODY><P>Olá,</P><P></P><P>Não precisa concatenar o seu novo LOAD com a tabela Capacidade, veja exemplo:</P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14743148240477808" jivemacro_uid="_14743148240477808" modifiedtitle="true"> <P>Capacidade_TMP:</P> <P>LOAD * INLINE [</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC, CAPAC_DIA</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-TAG, 1.350</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-BSB, 1.080</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-CEI, 1.296</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-FAM, 72</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-GUA, 324</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-PAR, 324</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-PLA, 540</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-SOB, 324</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-JEC, 2.592</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-AGC, 216</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-GAM, 324</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-RFU, 324</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-SAO, 324</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-BRZ, 324</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-EMA, 216</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-NUC, 324</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-SAM, 324</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-STA, 216</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-SUPER, 0</P> <P>];</P> <P></P> <P></P> <P>NoConcatenate</P> <P><SPAN style="color: rgba(0, 0, 0, 0); font-family: Consolas, 'Courier New', Courier, mono, serif; font-size: 12px;">Capacidade:</SPAN></P> <P>LOAD CEJUSC,</P> <P>&nbsp; CAPAC_DIA,</P> <P>&nbsp; IF(CAPAC_DIA &gt;= 0 AND CAPAC_DIA &lt; 300, 'Pequeno Porte',</P> <P>&nbsp;&nbsp; IF(CAPAC_DIA &gt;= 300 AND CAPAC_DIA &lt; 1000, 'Medio Porte',</P> <P>&nbsp; IF(CAPAC_DIA &gt;= 1000 AND CAPAC_DIA &lt; 2000, 'Grande Porte', 'Muito Grande Porte'))) AS CLASSIFICAÇÃO</P> <P>Resident <SPAN style="color: rgba(0, 0, 0, 0); font-family: Consolas, 'Courier New', Courier, mono, serif; font-size: 12px;">Capacidade_TMP</SPAN></P> <P>WHERE CEJUSC &lt;&gt; 0;</P> <P></P> <P></P> <P>DROP Table <SPAN style="color: rgba(0, 0, 0, 0); font-family: Consolas, 'Courier New', Courier, mono, serif; font-size: 12px;">Capacidade_TMP</SPAN>;</P> </PRE></BODY></HTML> Mon, 19 Sep 2016 19:54:26 GMT paulovendruscol 2016-09-19T19:54:26Z Coluna Calculada no Script https://community.qlik.com/t5/Brasil/Coluna-Calculada-no-Script/m-p/1187922#M41810 <HTML><HEAD></HEAD><BODY><P>Boa tarde pessoal. Criei uma coluna calculada no meu script com base em uma sugestão que encontrei em outro tópico.</P><P></P><P><EM>Capacidade:</EM></P><P><EM>LOAD * INLINE [</EM></P><P><EM>&nbsp;&nbsp;&nbsp; CEJUSC, CAPAC_DIA</EM></P><P><EM>&nbsp;&nbsp;&nbsp; CEJUSC-TAG, 1.350</EM></P><P><EM>&nbsp;&nbsp;&nbsp; CEJUSC-BSB, 1.080</EM></P><P><EM>&nbsp;&nbsp;&nbsp; CEJUSC-CEI, 1.296</EM></P><P><EM>&nbsp;&nbsp;&nbsp; CEJUSC-FAM, 72</EM></P><P><EM>&nbsp;&nbsp;&nbsp; CEJUSC-GUA, 324</EM></P><P><EM>&nbsp;&nbsp;&nbsp; CEJUSC-PAR, 324</EM></P><P><EM>&nbsp;&nbsp;&nbsp; CEJUSC-PLA, 540</EM></P><P><EM>&nbsp;&nbsp;&nbsp; CEJUSC-SOB, 324</EM></P><P><EM>&nbsp;&nbsp;&nbsp; CEJUSC-JEC, 2.592</EM></P><P><EM>&nbsp;&nbsp;&nbsp; CEJUSC-AGC, 216</EM></P><P><EM>&nbsp;&nbsp;&nbsp; CEJUSC-GAM, 324</EM></P><P><EM>&nbsp;&nbsp;&nbsp; CEJUSC-RFU, 324</EM></P><P><EM>&nbsp;&nbsp;&nbsp; CEJUSC-SAO, 324</EM></P><P><EM>&nbsp;&nbsp;&nbsp; CEJUSC-BRZ, 324</EM></P><P><EM>&nbsp;&nbsp;&nbsp; CEJUSC-EMA, 216</EM></P><P><EM>&nbsp;&nbsp;&nbsp; CEJUSC-NUC, 324</EM></P><P><EM>&nbsp;&nbsp;&nbsp; CEJUSC-SAM, 324</EM></P><P><EM>&nbsp;&nbsp;&nbsp; CEJUSC-STA, 216</EM></P><P><EM>&nbsp;&nbsp;&nbsp; CEJUSC-SUPER, 0</EM></P><P><EM>];</EM></P><P></P><P></P><P><EM>Concatenate (Capacidade)</EM></P><P><EM>LOAD CEJUSC,</EM></P><P><EM>&nbsp; CAPAC_DIA, </EM></P><P><EM>&nbsp; IF(CAPAC_DIA &gt;= 0 AND CAPAC_DIA &lt; 300, 'Pequeno Porte',</EM></P><P><EM>&nbsp;&nbsp; IF(CAPAC_DIA &gt;= 300 AND CAPAC_DIA &lt; 1000, 'Medio Porte',</EM></P><P><EM>&nbsp; IF(CAPAC_DIA &gt;= 1000 AND CAPAC_DIA &lt; 2000, 'Grande Porte', 'Muito Grande Porte'))) AS CLASSIFICAÇÃO</EM></P><P><EM>Resident Capacidade</EM></P><P><EM>WHERE CEJUSC &lt;&gt; 0</EM></P><P></P><P>Mas minha tabela final está aparecendo com duplicidade:</P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="1px" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 257px; border-width: 1px; border-style: solid;"><TBODY><TR><TD class="xl63" height="17" width="81">CEJUSC</TD><TD class="xl63" width="58">CAPAC_DIA</TD><TD class="xl63" width="118">CLASSIFICAÇÃO</TD></TR><TR><TD class="xl64" height="17">CEJUSC-AGC</TD><TD class="xl65">216</TD><TD class="xl65">Pequeno Porte</TD></TR><TR><TD class="xl64" height="17">CEJUSC-AGC</TD><TD class="xl65">216</TD><TD class="xl66"> </TD></TR><TR><TD class="xl64" height="17">CEJUSC-BRZ</TD><TD class="xl65">324</TD><TD class="xl65">Medio Porte</TD></TR><TR><TD class="xl64" height="17">CEJUSC-BRZ</TD><TD class="xl65">324</TD><TD class="xl66"> </TD></TR><TR><TD class="xl64" height="17">CEJUSC-BSB</TD><TD class="xl65">1.080</TD><TD class="xl65">Grande Porte</TD></TR><TR><TD class="xl64" height="17">CEJUSC-BSB</TD><TD class="xl65">1.080</TD><TD class="xl66"> </TD></TR><TR><TD class="xl64" height="17">CEJUSC-CEI</TD><TD class="xl65">1.296</TD><TD class="xl65">Grande Porte</TD></TR><TR><TD class="xl64" height="17">CEJUSC-CEI</TD><TD class="xl65">1.296</TD><TD class="xl66"> </TD></TR><TR><TD class="xl64" height="17">CEJUSC-EMA</TD><TD class="xl65">216</TD><TD class="xl65">Pequeno Porte</TD></TR><TR><TD class="xl64" height="17">CEJUSC-EMA</TD><TD class="xl65">216</TD><TD class="xl66"> </TD></TR><TR><TD class="xl64" height="17">CEJUSC-FAM</TD><TD class="xl65">72</TD><TD class="xl65">Pequeno Porte</TD></TR><TR><TD class="xl64" height="17">CEJUSC-FAM</TD><TD class="xl65">72</TD><TD class="xl66"> </TD></TR><TR><TD class="xl64" height="17">CEJUSC-GAM</TD><TD class="xl65">324</TD><TD class="xl65">Medio Porte</TD></TR><TR><TD class="xl64" height="17">CEJUSC-GAM</TD><TD class="xl65">324</TD><TD class="xl66"> </TD></TR><TR><TD class="xl64" height="17">CEJUSC-GUA</TD><TD class="xl65">324</TD><TD class="xl65">Medio Porte</TD></TR><TR><TD class="xl64" height="17">CEJUSC-GUA</TD><TD class="xl65">324</TD><TD class="xl66"> </TD></TR><TR><TD class="xl64" height="17">CEJUSC-JEC</TD><TD class="xl65">2.592</TD><TD class="xl65">Muito Grande Porte</TD></TR><TR><TD class="xl64" height="17">CEJUSC-JEC</TD><TD class="xl65">2.592</TD><TD class="xl66"> </TD></TR><TR><TD class="xl64" height="17">CEJUSC-NUC</TD><TD class="xl65">324</TD><TD class="xl65">Medio Porte</TD></TR><TR><TD class="xl64" height="17">CEJUSC-NUC</TD><TD class="xl65">324</TD><TD class="xl66"> </TD></TR><TR><TD class="xl64" height="17">CEJUSC-PAR</TD><TD class="xl65">324</TD><TD class="xl65">Medio Porte</TD></TR><TR><TD class="xl64" height="17">CEJUSC-PAR</TD><TD class="xl65">324</TD><TD class="xl66"> </TD></TR><TR><TD class="xl64" height="17">CEJUSC-PLA</TD><TD class="xl65">540</TD><TD class="xl65">Medio Porte</TD></TR><TR><TD class="xl64" height="17">CEJUSC-PLA</TD><TD class="xl65">540</TD><TD class="xl66"> </TD></TR><TR><TD class="xl64" height="17">CEJUSC-RFU</TD><TD class="xl65">324</TD><TD class="xl65">Medio Porte</TD></TR><TR><TD class="xl64" height="17">CEJUSC-RFU</TD><TD class="xl65">324</TD><TD class="xl66"> </TD></TR><TR><TD class="xl64" height="17">CEJUSC-SAM</TD><TD class="xl65">324</TD><TD class="xl65">Medio Porte</TD></TR><TR><TD class="xl64" height="17">CEJUSC-SAM</TD><TD class="xl65">324</TD><TD class="xl66"> </TD></TR><TR><TD class="xl64" height="17">CEJUSC-SAO</TD><TD class="xl65">324</TD><TD class="xl65">Medio Porte</TD></TR><TR><TD class="xl64" height="17">CEJUSC-SAO</TD><TD class="xl65">324</TD><TD class="xl66"> </TD></TR><TR><TD class="xl64" height="17">CEJUSC-SOB</TD><TD class="xl65">324</TD><TD class="xl65">Medio Porte</TD></TR><TR><TD class="xl64" height="17">CEJUSC-SOB</TD><TD class="xl65">324</TD><TD class="xl66"> </TD></TR><TR><TD class="xl64" height="17">CEJUSC-STA</TD><TD class="xl65">216</TD><TD class="xl65">Pequeno Porte</TD></TR><TR><TD class="xl64" height="17">CEJUSC-STA</TD><TD class="xl65">216</TD><TD class="xl66"> </TD></TR><TR><TD class="xl64" height="17">CEJUSC-SUPER</TD><TD class="xl65">0</TD><TD class="xl65">Pequeno Porte</TD></TR><TR><TD class="xl64" height="17">CEJUSC-SUPER</TD><TD class="xl65">0</TD><TD class="xl66"> </TD></TR><TR><TD class="xl64" height="17">CEJUSC-TAG</TD><TD class="xl65">1.350</TD><TD class="xl65">Grande Porte</TD></TR><TR><TD class="xl64" height="17">CEJUSC-TAG</TD><TD class="xl65">1.350</TD><TD class="xl66"> </TD></TR></TBODY></TABLE><P></P><P>Gostaria que aparecesse apenas a linha superior de cada CEJUSC.</P></BODY></HTML> Mon, 19 Sep 2016 19:23:40 GMT https://community.qlik.com/t5/Brasil/Coluna-Calculada-no-Script/m-p/1187922#M41810 2016-09-19T19:23:40Z Re: Coluna Calculada no Script https://community.qlik.com/t5/Brasil/Coluna-Calculada-no-Script/m-p/1187923#M41811 <HTML><HEAD></HEAD><BODY><P>Marina,</P><P></P><P>A primeira tabela deve ser dropada, ela serve apenas de auxiliar..<BR />Deixe assim:</P><P></P><P></P><P></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">Capacidade:</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">LOAD * INLINE [</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC, CAPAC_DIA</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-TAG, 1.350</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-BSB, 1.080</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-CEI, 1.296</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-FAM, 72</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-GUA, 324</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-PAR, 324</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-PLA, 540</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-SOB, 324</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-JEC, 2.592</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-AGC, 216</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-GAM, 324</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-RFU, 324</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-SAO, 324</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-BRZ, 324</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-EMA, 216</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-NUC, 324</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-SAM, 324</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-STA, 216</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-SUPER, 0</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">];</EM></P><P></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">NoConcatenate</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">CapacidadeFinal:<BR /></EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">LOAD CEJUSC,</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp; CAPAC_DIA,</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp; IF(CAPAC_DIA &gt;= 0 AND CAPAC_DIA &lt; 300, 'Pequeno Porte',</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp; IF(CAPAC_DIA &gt;= 300 AND CAPAC_DIA &lt; 1000, 'Medio Porte',</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp; IF(CAPAC_DIA &gt;= 1000 AND CAPAC_DIA &lt; 2000, 'Grande Porte', 'Muito Grande Porte'))) AS CLASSIFICAÇÃO</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">Resident Capacidade</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">WHERE CEJUSC &lt;&gt; 0</EM></P><P></P><P></P><P>drop table <EM style="color: #3d3d3d; font-family: inherit; font-size: 13px; font-weight: inherit;">Capacidade;</EM></P></BODY></HTML> Mon, 19 Sep 2016 19:42:51 GMT https://community.qlik.com/t5/Brasil/Coluna-Calculada-no-Script/m-p/1187923#M41811 klaus_gibin 2016-09-19T19:42:51Z Re: Coluna Calculada no Script https://community.qlik.com/t5/Brasil/Coluna-Calculada-no-Script/m-p/1187924#M41812 <HTML><HEAD></HEAD><BODY><P>Olá,</P><P></P><P>Não precisa concatenar o seu novo LOAD com a tabela Capacidade, veja exemplo:</P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14743148240477808" jivemacro_uid="_14743148240477808" modifiedtitle="true"> <P>Capacidade_TMP:</P> <P>LOAD * INLINE [</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC, CAPAC_DIA</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-TAG, 1.350</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-BSB, 1.080</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-CEI, 1.296</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-FAM, 72</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-GUA, 324</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-PAR, 324</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-PLA, 540</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-SOB, 324</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-JEC, 2.592</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-AGC, 216</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-GAM, 324</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-RFU, 324</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-SAO, 324</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-BRZ, 324</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-EMA, 216</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-NUC, 324</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-SAM, 324</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-STA, 216</P> <P>&nbsp;&nbsp;&nbsp; CEJUSC-SUPER, 0</P> <P>];</P> <P></P> <P></P> <P>NoConcatenate</P> <P><SPAN style="color: rgba(0, 0, 0, 0); font-family: Consolas, 'Courier New', Courier, mono, serif; font-size: 12px;">Capacidade:</SPAN></P> <P>LOAD CEJUSC,</P> <P>&nbsp; CAPAC_DIA,</P> <P>&nbsp; IF(CAPAC_DIA &gt;= 0 AND CAPAC_DIA &lt; 300, 'Pequeno Porte',</P> <P>&nbsp;&nbsp; IF(CAPAC_DIA &gt;= 300 AND CAPAC_DIA &lt; 1000, 'Medio Porte',</P> <P>&nbsp; IF(CAPAC_DIA &gt;= 1000 AND CAPAC_DIA &lt; 2000, 'Grande Porte', 'Muito Grande Porte'))) AS CLASSIFICAÇÃO</P> <P>Resident <SPAN style="color: rgba(0, 0, 0, 0); font-family: Consolas, 'Courier New', Courier, mono, serif; font-size: 12px;">Capacidade_TMP</SPAN></P> <P>WHERE CEJUSC &lt;&gt; 0;</P> <P></P> <P></P> <P>DROP Table <SPAN style="color: rgba(0, 0, 0, 0); font-family: Consolas, 'Courier New', Courier, mono, serif; font-size: 12px;">Capacidade_TMP</SPAN>;</P> </PRE></BODY></HTML> Mon, 19 Sep 2016 19:54:26 GMT https://community.qlik.com/t5/Brasil/Coluna-Calculada-no-Script/m-p/1187924#M41812 paulovendruscol 2016-09-19T19:54:26Z Re: Coluna Calculada no Script https://community.qlik.com/t5/Brasil/Coluna-Calculada-no-Script/m-p/1187925#M41813 <HTML><HEAD></HEAD><BODY><P>Você pode fazer usando um resident</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><EM style="font-weight: inherit; font-family: inherit;">Capacidade:</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><EM style="font-weight: inherit; font-family: inherit;">LOAD CEJUSC,</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp; CAPAC_DIA,</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp; IF(CAPAC_DIA &gt;= 0 AND CAPAC_DIA &lt; 300, 'Pequeno Porte',</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp; IF(CAPAC_DIA &gt;= 300 AND CAPAC_DIA &lt; 1000, 'Medio Porte',</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp; IF(CAPAC_DIA &gt;= 1000 AND CAPAC_DIA &lt; 2000, 'Grande Porte', 'Muito Grande Porte'))) AS CLASSIFICAÇÃO</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><EM style="font-weight: inherit; font-family: inherit;">WHERE CEJUSC &lt;&gt; 0;</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><EM style="font-weight: inherit; font-family: inherit;">LOAD * INLINE [</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC, CAPAC_DIA</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-TAG, 1.350</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-BSB, 1.080</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-CEI, 1.296</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-FAM, 72</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-GUA, 324</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-PAR, 324</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-PLA, 540</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-SOB, 324</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-JEC, 2.592</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-AGC, 216</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-GAM, 324</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-RFU, 324</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-SAO, 324</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-BRZ, 324</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-EMA, 216</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-NUC, 324</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-SAM, 324</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-STA, 216</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><EM style="font-weight: inherit; font-family: inherit;">&nbsp;&nbsp;&nbsp; CEJUSC-SUPER, 0</EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><EM style="font-weight: inherit; font-family: inherit;">];</EM></P></BODY></HTML> Mon, 19 Sep 2016 19:57:26 GMT https://community.qlik.com/t5/Brasil/Coluna-Calculada-no-Script/m-p/1187925#M41813 Clever_Anjos 2016-09-19T19:57:26Z