topic Qlikview between entre datas. in QlikView https://community.qlik.com/t5/QlikView/Qlikview-between-entre-datas/m-p/421149#M564559 <HTML><HEAD></HEAD><BODY><P>Ola pessoal.</P><P></P><P>Estou com o seguinte problema, tenho uma tabela de cliente com os campos DTINICIO e DTFIM e Tenho como filtro uma lista de valor DTREFERENCIA. Agora eu precisava calcular a quantidade de clientes que estão naquela data. Exemplo:</P><P></P><P></P><P>DTREFERENCIA = 01/2011</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="margin-left: 3.25pt; width: 215px;"><TBODY><TR><TD nowrap="nowrap" style="border: 1pt solid windowtext; padding: 0px 3.5pt; text-align: center;" valign="bottom" width="64"><P style="margin-bottom: 0.0001pt;"><SPAN style="color: black;">Nome</SPAN></P></TD><TD nowrap="nowrap" style="border-style: solid solid solid none; border-top-color: windowtext; border-right-color: windowtext; border-bottom-color: windowtext; border-top-width: 1pt; border-right-width: 1pt; border-bottom-width: 1pt; padding: 0px 3.5pt; text-align: center;" valign="bottom" width="87"><P style="margin-bottom: 0.0001pt;"><SPAN style="color: black;">DTINICIO</SPAN></P></TD><TD nowrap="nowrap" style="border-style: solid solid solid none; border-top-color: windowtext; border-right-color: windowtext; border-bottom-color: windowtext; border-top-width: 1pt; border-right-width: 1pt; border-bottom-width: 1pt; padding: 0px 3.5pt; text-align: center;" valign="bottom" width="64"><P style="margin-bottom: 0.0001pt;"><SPAN style="color: black;">DTFIM </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 style="margin-bottom: 0.0001pt;"><SPAN style="color: black;">Cliente 1</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="87"><P align="right" style="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="color: black;">01/2010</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="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="color: black;">12/2010</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 style="margin-bottom: 0.0001pt;"><SPAN style="color: black;">Cliente 2</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="87"><P align="right" style="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="color: black;">02/2010</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="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="color: black;">10/2012</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 style="margin-bottom: 0.0001pt;"><SPAN style="color: black;">Cliente 3</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="87"><P align="right" style="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="color: black;">08/2010</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="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="color: black;">10/2011</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 style="margin-bottom: 0.0001pt;"><SPAN style="color: black;">Cliente 4</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="87"><P align="right" style="margin-bottom: 0.0001pt; text-align: right;">01/2011</P></TD><TD><BR /></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 style="margin-bottom: 0.0001pt;"><SPAN style="color: black;">Cliente 5</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="87"><P align="right" style="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="color: black;">10/2012</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 style="margin-bottom: 0.0001pt;"><SPAN style="color: black;"> </SPAN></P></TD></TR></TBODY></TABLE><P></P><P>Resultado:</P><P>Cliente 2,</P><P> Cliente 3, </P><P>Cliente 4</P><P></P><P>Ou seja, total 3 cliente.</P><P></P><P>Como que eu posso fazer isso ?</P><P></P><P>obs: Esse resultado irei multiplicar por outro campo que vem de outra tabela associado ao codigo do cliente, e o resultado serar mostrado em forma de grafico.</P></BODY></HTML> Mon, 14 Jan 2013 17:58:52 GMT 2013-01-14T17:58:52Z Qlikview between entre datas. https://community.qlik.com/t5/QlikView/Qlikview-between-entre-datas/m-p/421149#M564559 <HTML><HEAD></HEAD><BODY><P>Ola pessoal.</P><P></P><P>Estou com o seguinte problema, tenho uma tabela de cliente com os campos DTINICIO e DTFIM e Tenho como filtro uma lista de valor DTREFERENCIA. Agora eu precisava calcular a quantidade de clientes que estão naquela data. Exemplo:</P><P></P><P></P><P>DTREFERENCIA = 01/2011</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="margin-left: 3.25pt; width: 215px;"><TBODY><TR><TD nowrap="nowrap" style="border: 1pt solid windowtext; padding: 0px 3.5pt; text-align: center;" valign="bottom" width="64"><P style="margin-bottom: 0.0001pt;"><SPAN style="color: black;">Nome</SPAN></P></TD><TD nowrap="nowrap" style="border-style: solid solid solid none; border-top-color: windowtext; border-right-color: windowtext; border-bottom-color: windowtext; border-top-width: 1pt; border-right-width: 1pt; border-bottom-width: 1pt; padding: 0px 3.5pt; text-align: center;" valign="bottom" width="87"><P style="margin-bottom: 0.0001pt;"><SPAN style="color: black;">DTINICIO</SPAN></P></TD><TD nowrap="nowrap" style="border-style: solid solid solid none; border-top-color: windowtext; border-right-color: windowtext; border-bottom-color: windowtext; border-top-width: 1pt; border-right-width: 1pt; border-bottom-width: 1pt; padding: 0px 3.5pt; text-align: center;" valign="bottom" width="64"><P style="margin-bottom: 0.0001pt;"><SPAN style="color: black;">DTFIM </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 style="margin-bottom: 0.0001pt;"><SPAN style="color: black;">Cliente 1</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="87"><P align="right" style="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="color: black;">01/2010</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="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="color: black;">12/2010</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 style="margin-bottom: 0.0001pt;"><SPAN style="color: black;">Cliente 2</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="87"><P align="right" style="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="color: black;">02/2010</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="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="color: black;">10/2012</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 style="margin-bottom: 0.0001pt;"><SPAN style="color: black;">Cliente 3</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="87"><P align="right" style="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="color: black;">08/2010</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="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="color: black;">10/2011</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 style="margin-bottom: 0.0001pt;"><SPAN style="color: black;">Cliente 4</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="87"><P align="right" style="margin-bottom: 0.0001pt; text-align: right;">01/2011</P></TD><TD><BR /></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 style="margin-bottom: 0.0001pt;"><SPAN style="color: black;">Cliente 5</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="87"><P align="right" style="margin-bottom: 0.0001pt; text-align: right;"><SPAN style="color: black;">10/2012</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 style="margin-bottom: 0.0001pt;"><SPAN style="color: black;"> </SPAN></P></TD></TR></TBODY></TABLE><P></P><P>Resultado:</P><P>Cliente 2,</P><P> Cliente 3, </P><P>Cliente 4</P><P></P><P>Ou seja, total 3 cliente.</P><P></P><P>Como que eu posso fazer isso ?</P><P></P><P>obs: Esse resultado irei multiplicar por outro campo que vem de outra tabela associado ao codigo do cliente, e o resultado serar mostrado em forma de grafico.</P></BODY></HTML> Mon, 14 Jan 2013 17:58:52 GMT https://community.qlik.com/t5/QlikView/Qlikview-between-entre-datas/m-p/421149#M564559 2013-01-14T17:58:52Z