topic Re: criar coluna in Brasil https://community.qlik.com/t5/Brasil/criar-coluna/m-p/643369#M18023 <HTML><HEAD></HEAD><BODY><P>Hehe</P><P>Não tinha visto sua resposta, Eduardo.</P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Abs,</SPAN></P><P>Felipe</P></BODY></HTML> Fri, 06 Jun 2014 22:47:20 GMT felipe_dutra 2014-06-06T22:47:20Z criar coluna https://community.qlik.com/t5/Brasil/criar-coluna/m-p/643367#M18021 <HTML><HEAD></HEAD><BODY><P>boa tarde a todos!</P><P>preciso de ajuda!</P><P>tenho 3 colunas (cartão; boleto; cheque)</P><P>onde cada coluna tem seus valores!</P><P>preciso criar uma quarta coluna onde identifique o que é cartão; boleto ou cheque como a quarta coluna abaixo!</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 286px;"><TBODY><TR><TD height="17" width="64">boleto</TD><TD width="64">cartão</TD><TD width="64">cheque</TD><TD class="xl65" width="94">forma de pagto</TD></TR><TR><TD align="right" height="17">10</TD><TD align="right">0</TD><TD align="right">0</TD><TD class="xl65">boleto</TD></TR><TR><TD align="right" height="17">15,75</TD><TD align="right">0</TD><TD align="right">0</TD><TD class="xl65">boleto</TD></TR><TR><TD align="right" height="17">0</TD><TD align="right">85,52</TD><TD align="right">0</TD><TD class="xl65">cartão</TD></TR><TR><TD align="right" height="17">0</TD><TD align="right">1,98</TD><TD align="right">0</TD><TD class="xl65">cartão</TD></TR><TR><TD align="right" height="17">0</TD><TD align="right">0</TD><TD align="right">98,55</TD><TD class="xl65">cheque</TD></TR><TR><TD align="right" height="17">0</TD><TD align="right">0</TD><TD align="right">95</TD><TD class="xl65">cheque</TD></TR></TBODY></TABLE><P></P><P>desde já agradeço</P></BODY></HTML> Fri, 06 Jun 2014 21:05:47 GMT https://community.qlik.com/t5/Brasil/criar-coluna/m-p/643367#M18021 2014-06-06T21:05:47Z Re: criar coluna https://community.qlik.com/t5/Brasil/criar-coluna/m-p/643368#M18022 <HTML><HEAD></HEAD><BODY><P>No script:</P><P>if (boleto&gt;0, 'boleto',</P><P>&nbsp;&nbsp; if(cartao &gt; 0, 'cartao', 'cheque')) as FormaPagamento</P><P></P><P>Eduardo</P></BODY></HTML> Fri, 06 Jun 2014 22:36:11 GMT https://community.qlik.com/t5/Brasil/criar-coluna/m-p/643368#M18022 eduardo_sommer 2014-06-06T22:36:11Z Re: criar coluna https://community.qlik.com/t5/Brasil/criar-coluna/m-p/643369#M18023 <HTML><HEAD></HEAD><BODY><P>Hehe</P><P>Não tinha visto sua resposta, Eduardo.</P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Abs,</SPAN></P><P>Felipe</P></BODY></HTML> Fri, 06 Jun 2014 22:47:20 GMT https://community.qlik.com/t5/Brasil/criar-coluna/m-p/643369#M18023 felipe_dutra 2014-06-06T22:47:20Z Re: criar coluna https://community.qlik.com/t5/Brasil/criar-coluna/m-p/643370#M18024 <HTML><HEAD></HEAD><BODY><P>Você estava colocando a mesma resposta, hehe?</P><P></P><P>Eduardo</P></BODY></HTML> Fri, 06 Jun 2014 22:56:19 GMT https://community.qlik.com/t5/Brasil/criar-coluna/m-p/643370#M18024 eduardo_sommer 2014-06-06T22:56:19Z Re: criar coluna https://community.qlik.com/t5/Brasil/criar-coluna/m-p/643371#M18025 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Sim!</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Abs,</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Felipe<BR /></SPAN></P></BODY></HTML> Fri, 06 Jun 2014 23:00:45 GMT https://community.qlik.com/t5/Brasil/criar-coluna/m-p/643371#M18025 felipe_dutra 2014-06-06T23:00:45Z