https://community.qlik.com/t5/App-Development/Filtrar-90-dos-registros-existentes/m-p/2461895#M98913 <P>Prezados, boa tarde.</P> <P>Estou precisando de uma maneira para que eu possa criar um filtro que me retorne de forma automática 90% dos registros existentes na minha tabela.</P> <P>Exemplo, tenho uma tabela com ID e Hora Útil conforme a tabela, gostaria de criar um filtro para que retornasse somente os 9 primeiros registros, para que posteriormente eu pudesse fazer a média de hora útil somente desses registros.&nbsp;</P> <TABLE style="border-collapse: collapse; width: 96pt;" border="0" width="128" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 15.75pt;"> <TD width="64" height="21" class="xl65" style="height: 15.75pt; width: 48pt;">ID</TD> <TD width="64" class="xl65" style="border-left: none; width: 48pt;">HORA ÚTIL</TD> </TR> <TR style="height: 15.75pt;"> <TD height="21" align="right" class="xl65" style="height: 15.75pt; border-top: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> </TR> <TR style="height: 15.75pt;"> <TD height="21" align="right" class="xl65" style="height: 15.75pt; border-top: none;">2</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">4</TD> </TR> <TR style="height: 15.75pt;"> <TD height="21" align="right" class="xl65" style="height: 15.75pt; border-top: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">5</TD> </TR> <TR style="height: 15.75pt;"> <TD height="21" align="right" class="xl65" style="height: 15.75pt; border-top: none;">4</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2</TD> </TR> <TR style="height: 15.75pt;"> <TD height="21" align="right" class="xl65" style="height: 15.75pt; border-top: none;">5</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> </TR> <TR style="height: 15.75pt;"> <TD height="21" align="right" class="xl65" style="height: 15.75pt; border-top: none;">6</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">5</TD> </TR> <TR style="height: 15.75pt;"> <TD height="21" align="right" class="xl65" style="height: 15.75pt; border-top: none;">7</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">6</TD> </TR> <TR style="height: 15.75pt;"> <TD height="21" align="right" class="xl65" style="height: 15.75pt; border-top: none;">8</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">7</TD> </TR> <TR style="height: 15.75pt;"> <TD height="21" align="right" class="xl65" style="height: 15.75pt; border-top: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> </TR> <TR style="height: 15.75pt;"> <TD height="21" align="right" class="xl65" style="height: 15.75pt; border-top: none;">10</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Obrigado</P> Wed, 12 Jun 2024 19:26:09 GMT vitorgf52 2024-06-12T19:26:09Z https://community.qlik.com/t5/App-Development/Filtrar-90-dos-registros-existentes/m-p/2461895#M98913 <P>Prezados, boa tarde.</P> <P>Estou precisando de uma maneira para que eu possa criar um filtro que me retorne de forma automática 90% dos registros existentes na minha tabela.</P> <P>Exemplo, tenho uma tabela com ID e Hora Útil conforme a tabela, gostaria de criar um filtro para que retornasse somente os 9 primeiros registros, para que posteriormente eu pudesse fazer a média de hora útil somente desses registros.&nbsp;</P> <TABLE style="border-collapse: collapse; width: 96pt;" border="0" width="128" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 15.75pt;"> <TD width="64" height="21" class="xl65" style="height: 15.75pt; width: 48pt;">ID</TD> <TD width="64" class="xl65" style="border-left: none; width: 48pt;">HORA ÚTIL</TD> </TR> <TR style="height: 15.75pt;"> <TD height="21" align="right" class="xl65" style="height: 15.75pt; border-top: none;">1</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> </TR> <TR style="height: 15.75pt;"> <TD height="21" align="right" class="xl65" style="height: 15.75pt; border-top: none;">2</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">4</TD> </TR> <TR style="height: 15.75pt;"> <TD height="21" align="right" class="xl65" style="height: 15.75pt; border-top: none;">3</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">5</TD> </TR> <TR style="height: 15.75pt;"> <TD height="21" align="right" class="xl65" style="height: 15.75pt; border-top: none;">4</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">2</TD> </TR> <TR style="height: 15.75pt;"> <TD height="21" align="right" class="xl65" style="height: 15.75pt; border-top: none;">5</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> </TR> <TR style="height: 15.75pt;"> <TD height="21" align="right" class="xl65" style="height: 15.75pt; border-top: none;">6</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">5</TD> </TR> <TR style="height: 15.75pt;"> <TD height="21" align="right" class="xl65" style="height: 15.75pt; border-top: none;">7</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">6</TD> </TR> <TR style="height: 15.75pt;"> <TD height="21" align="right" class="xl65" style="height: 15.75pt; border-top: none;">8</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">7</TD> </TR> <TR style="height: 15.75pt;"> <TD height="21" align="right" class="xl65" style="height: 15.75pt; border-top: none;">9</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD> </TR> <TR style="height: 15.75pt;"> <TD height="21" align="right" class="xl65" style="height: 15.75pt; border-top: none;">10</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Obrigado</P> Wed, 12 Jun 2024 19:26:09 GMT https://community.qlik.com/t5/App-Development/Filtrar-90-dos-registros-existentes/m-p/2461895#M98913 vitorgf52 2024-06-12T19:26:09Z