topic Re: Dúvida Qlikview in Brasil https://community.qlik.com/t5/Brasil/D%C3%BAvida-Qlikview/m-p/409440#M11392 <HTML><HEAD></HEAD><BODY><P>O Kaauan tem razão Larissa,</P><P></P><P>Não consegui entender exatamente o que pretende, mas dê uma olhada na função GetFieldValue na ajuda (F1), pode lhe ajudar.</P><P></P><P>Se puder, anexa um QVW de exemplo... </P><P></P><P>Abraço.</P></BODY></HTML> Wed, 06 Feb 2013 20:05:06 GMT aderlanrm 2013-02-06T20:05:06Z Dúvida Qlikview https://community.qlik.com/t5/Brasil/D%C3%BAvida-Qlikview/m-p/409438#M11390 <HTML><HEAD></HEAD><BODY><P>Gente, </P><P></P><P>Estou com um problema e não consigo chegar em uma solução.</P><P></P><P> <SPAN style="color: #1f497d;">Possuímos um relatório para analisar alguns dados, todos os valores são do referentes ao mês selecionado + 12 meses atrás, vamos usar estes dados como exemplo :</SPAN></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="208"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P><SPAN style="color: black;">Ano</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="80"><P><SPAN style="color: black;">Quantidade</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P><SPAN style="color: black;">Custo</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P><SPAN style="color: black;">2011/01</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">10</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">1000</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P><SPAN style="color: black;">2011/02</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">10</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">1000</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P><SPAN style="color: black;">2011/03</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">8</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">800</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P><SPAN style="color: black;">2011/04</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">8</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">800</SPAN></P></TD></TR></TBODY></TABLE><P></P><P></P><P><SPAN style="color: #1f497d;">Temos os filtros de data e um filtro com a opção de (Ativos no Inicio da Apólice e Ativos no Último mês).</SPAN></P><P></P><P><SPAN style="color: #1f497d;">Quando clicamos em Ativos no Inicio da Apólice e a data de 2011/04, temos:</SPAN></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="208"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P><SPAN style="color: black;">Ano</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="80"><P><SPAN style="color: black;">Quantidade</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P><SPAN style="color: black;">Custo</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P><SPAN style="color: black;">2011/01</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">0</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">1000</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P><SPAN style="color: black;">2011/02</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">0</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">1000</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P><SPAN style="color: black;">2011/03</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">0</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">800</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P><SPAN style="color: black;">2011/04</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">8</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">800</SPAN></P></TD></TR></TBODY></TABLE><P></P><P><SPAN style="color: #1f497d;">Esta correto, ele mostra a quantidade de 8 e o custo de 800 para&nbsp; Abril e o custo que tiveram os demais meses.</SPAN></P><P></P><P></P><P><SPAN style="color: #1f497d;">Ao clicar em Ativos no Último mês e a data de 2011/04, temos:</SPAN></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="208"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P><SPAN style="color: black;">Ano</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="80"><P><SPAN style="color: black;">Quantidade</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P><SPAN style="color: black;">Custo</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P><SPAN style="color: black;">2011/01</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">0</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">1000</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P><SPAN style="color: black;">2011/02</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">0</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">1000</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P><SPAN style="color: black;">2011/03</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">0</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">800</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P><SPAN style="color: black;">2011/04</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">8</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">800</SPAN></P></TD></TR></TBODY></TABLE><P></P><P><SPAN style="color: #1f497d;">Quando na verdade gostaria que aparecem os valores dos demais meses com relação a quantidade do mês selecionado, como no exemplo abaixo:</SPAN></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="208"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P><SPAN style="color: black;">Ano</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="80"><P><SPAN style="color: black;">Quantidade</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P><SPAN style="color: black;">Custo</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P><SPAN style="color: black;">2011/01</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">0</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">800</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P><SPAN style="color: black;">2011/02</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">0</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">800</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P><SPAN style="color: black;">2011/03</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">0</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">800</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P><SPAN style="color: black;">2011/04</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">8</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">800</SPAN></P></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 06 Feb 2013 12:08:05 GMT https://community.qlik.com/t5/Brasil/D%C3%BAvida-Qlikview/m-p/409438#M11390 2013-02-06T12:08:05Z Re: Dúvida Qlikview https://community.qlik.com/t5/Brasil/D%C3%BAvida-Qlikview/m-p/409439#M11391 <HTML><HEAD></HEAD><BODY><P>Oi Larissa,</P><P></P><P>Poderia postar o .qvw pra olharmos o que você fez extatamente? fica mais facil pra ajudar..&nbsp; </P><P></P><P>=D</P></BODY></HTML> Wed, 06 Feb 2013 12:22:38 GMT https://community.qlik.com/t5/Brasil/D%C3%BAvida-Qlikview/m-p/409439#M11391 matzenbacher 2013-02-06T12:22:38Z Re: Dúvida Qlikview https://community.qlik.com/t5/Brasil/D%C3%BAvida-Qlikview/m-p/409440#M11392 <HTML><HEAD></HEAD><BODY><P>O Kaauan tem razão Larissa,</P><P></P><P>Não consegui entender exatamente o que pretende, mas dê uma olhada na função GetFieldValue na ajuda (F1), pode lhe ajudar.</P><P></P><P>Se puder, anexa um QVW de exemplo... </P><P></P><P>Abraço.</P></BODY></HTML> Wed, 06 Feb 2013 20:05:06 GMT https://community.qlik.com/t5/Brasil/D%C3%BAvida-Qlikview/m-p/409440#M11392 aderlanrm 2013-02-06T20:05:06Z