topic Disregard selected filter in set analysis in App Development https://community.qlik.com/t5/App-Development/Disregard-selected-filter-in-set-analysis/m-p/2015149#M83868 <P>I'm doing an explicit filter on Sequence 783360, like the figure below.</P> <P>set analyzes that I am used for column Jan.</P> <P><SPAN>f(Only(Sequencia)&lt;&gt;0,</SPAN><BR /><SPAN>Sum({1&lt;Data_Efetivado_Estoque = {"{1}&gt;=$(vDataInicial) {1}&lt;=$(vDataFinal)"}, [Movimento_Tipo_Operacao]={'DEV','VND','VPC','VEF','FPV','CVE'},[Mes]={'jan'},[Dt_Passou1]={'0'} &gt;}Movimento_Prod_Serv_Qtde))</SPAN></P> <P><SPAN>I would like it when I filter the sequence 783360. It doesn't consider the filter for Jan Sales the same as set analys above which is wrong and needs help to correct.</SPAN></P> <P>&nbsp;</P> <TABLE width="801"> <TBODY> <TR> <TD width="45">Cod</TD> <TD width="327">Nome</TD> <TD width="98">Sequencia</TD> <TD width="84">Jan&nbsp;&nbsp;&nbsp;&nbsp;</TD> <TD width="99">Vendas Qtde</TD> <TD width="84">Jan&nbsp; (Valor Correto)&nbsp;</TD> <TD width="64">&nbsp;</TD> </TR> <TR> <TD>12258</TD> <TD>Pasta "L" OF 0,15mm Ref.1134 Fume</TD> <TD>783360</TD> <TD>0</TD> <TD>40</TD> <TD>30</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>16106</TD> <TD>Arquivo Morto Plast Aberto Ref.2607 Alaplast Azul</TD> <TD>783360</TD> <TD>0</TD> <TD>10</TD> <TD>15</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>15677</TD> <TD>Saco p/Lixo 100Lt c/5Un Sacolmax Preto</TD> <TD>783360</TD> <TD>0</TD> <TD>8</TD> <TD>17</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>21016</TD> <TD>Pastilha Sanit. Adesiva Pato 9g c/3Un Lavanda</TD> <TD>783360</TD> <TD>0</TD> <TD>6</TD> <TD>18</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>7055</TD> <TD>Pasta c/Elást. Plast. OF Ref.1021 Cristal</TD> <TD>783360</TD> <TD>0</TD> <TD>5</TD> <TD>40</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>22631</TD> <TD>Desodorizador 360ml Cerejeira de Kyo Secar</TD> <TD>783360</TD> <TD>0</TD> <TD>3</TD> <TD>30</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>18982</TD> <TD>Flanela 38x58 Santa Margarida Laranja</TD> <TD>783360</TD> <TD>0</TD> <TD>3</TD> <TD>25</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>6744</TD> <TD>Pano de Chão Bco Alvejado Grosso 43x65 S.Margarida</TD> <TD>783360</TD> <TD>0</TD> <TD>3</TD> <TD>30</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>24541</TD> <TD>Papel Toalha Interf. 1250Fls New Paper 100%Cel</TD> <TD>783360</TD> <TD>0</TD> <TD>3</TD> <TD>40</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>5559</TD> <TD>Pincel Marca Texto Lumi Color Ref: 200-SL Amarelo</TD> <TD>783360</TD> <TD>0</TD> <TD>3</TD> <TD>12</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>15371</TD> <TD>Fita Plast. 48x50 Ref.PP33TR Transparente</TD> <TD>783360</TD> <TD>0</TD> <TD>2</TD> <TD>12</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>9637</TD> <TD>Limpador Veja Limpeza Pesada X-14 2/1 500ml Cloro</TD> <TD>783360</TD> <TD>0</TD> <TD>2</TD> <TD>12</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>26938</TD> <TD>Máscara Desc. Cirur Tripla c/50 Ref.42018 Cx.Verde</TD> <TD>783360</TD> <TD>0</TD> <TD>2</TD> <TD>12</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>17459</TD> <TD>Papel Sulf. A4 75g/m² 500Fls Branco</TD> <TD>783360</TD> <TD>0</TD> <TD>2</TD> <TD>12</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>21365</TD> <TD>Alcool Gel Antisséptico 70% 5Lt All Clean Audax</TD> <TD>783360</TD> <TD>0</TD> <TD>1</TD> <TD>12</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>24432</TD> <TD>Papel Hig Rolao 8x500 New Paper 100%Cel</TD> <TD>783360</TD> <TD>0</TD> <TD>1</TD> <TD>12</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>16918</TD> <TD>Seven Revest Wax 5Lt Ref.5629</TD> <TD>783360</TD> <TD>0</TD> <TD>1</TD> <TD>12</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>24842</TD> <TD>Vassoura Nylon Cristal Tradic c/Cabo 1,20M c/ Capa</TD> <TD>783360</TD> <TD>0</TD> <TD>1</TD> <TD>12</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>8354</TD> <TD>Envelope 240x340 80g Ref.SKN034/334 Kraft Natural</TD> <TD>736870</TD> <TD>2.000</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>23087</TD> <TD>Fibra Limpeza Macia 100x260mm British Branca</TD> <TD>736198</TD> <TD>2.000</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>20896</TD> <TD>Pincel Marc. Perman. Ref: N450-C Azul</TD> <TD>737282</TD> <TD>1.758</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>14667</TD> <TD>Envelope Plást. 4 Furos 0.20 A4 Ref.020/4F A4</TD> <TD>736979</TD> <TD>1.600</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>26902</TD> <TD>Saco Plást AD 3Kg 24x38x0,03 c/100Un Segplast</TD> <TD>734469</TD> <TD>1.200</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>20677</TD> <TD>Sabonete p/Hotel 20g Alma de Flores</TD> <TD>733468</TD> <TD>1.042</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>14667</TD> <TD>Envelope Plást. 4 Furos 0.20 A4 Ref.020/4F A4</TD> <TD>733485</TD> <TD>1.000</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>14667</TD> <TD>Envelope Plást. 4 Furos 0.20 A4 Ref.020/4F A4</TD> <TD>733999</TD> <TD>1.000</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>15069</TD> <TD>Pano de Chão Bco Alvejado Fino 38x58cm Itatex</TD> <TD>736482</TD> <TD>1.000</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>15678</TD> <TD>Saco p/Lixo 200Lt c/5Un Sacolmax Preto</TD> <TD>734456</TD> <TD>1.000</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>25600</TD> <TD>Envelope Plást. Multiuso 13/11 Furos A4 Ref.1360</TD> <TD>735591</TD> <TD>937</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I need only the sequence 783360 to appear. Hiding the Sequence filter in the column Jan. bringing the correct values of the month Jan.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2022-12-11_08-11-54.jpg" style="width: 881px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/95917i704843E5F97BAA12/image-size/large?v=v2&amp;px=999" role="button" title="2022-12-11_08-11-54.jpg" alt="2022-12-11_08-11-54.jpg" /></span></P> <P>&nbsp;</P> Sun, 11 Dec 2022 12:02:23 GMT Ribeiro 2022-12-11T12:02:23Z Disregard selected filter in set analysis https://community.qlik.com/t5/App-Development/Disregard-selected-filter-in-set-analysis/m-p/2015149#M83868 <P>I'm doing an explicit filter on Sequence 783360, like the figure below.</P> <P>set analyzes that I am used for column Jan.</P> <P><SPAN>f(Only(Sequencia)&lt;&gt;0,</SPAN><BR /><SPAN>Sum({1&lt;Data_Efetivado_Estoque = {"{1}&gt;=$(vDataInicial) {1}&lt;=$(vDataFinal)"}, [Movimento_Tipo_Operacao]={'DEV','VND','VPC','VEF','FPV','CVE'},[Mes]={'jan'},[Dt_Passou1]={'0'} &gt;}Movimento_Prod_Serv_Qtde))</SPAN></P> <P><SPAN>I would like it when I filter the sequence 783360. It doesn't consider the filter for Jan Sales the same as set analys above which is wrong and needs help to correct.</SPAN></P> <P>&nbsp;</P> <TABLE width="801"> <TBODY> <TR> <TD width="45">Cod</TD> <TD width="327">Nome</TD> <TD width="98">Sequencia</TD> <TD width="84">Jan&nbsp;&nbsp;&nbsp;&nbsp;</TD> <TD width="99">Vendas Qtde</TD> <TD width="84">Jan&nbsp; (Valor Correto)&nbsp;</TD> <TD width="64">&nbsp;</TD> </TR> <TR> <TD>12258</TD> <TD>Pasta "L" OF 0,15mm Ref.1134 Fume</TD> <TD>783360</TD> <TD>0</TD> <TD>40</TD> <TD>30</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>16106</TD> <TD>Arquivo Morto Plast Aberto Ref.2607 Alaplast Azul</TD> <TD>783360</TD> <TD>0</TD> <TD>10</TD> <TD>15</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>15677</TD> <TD>Saco p/Lixo 100Lt c/5Un Sacolmax Preto</TD> <TD>783360</TD> <TD>0</TD> <TD>8</TD> <TD>17</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>21016</TD> <TD>Pastilha Sanit. Adesiva Pato 9g c/3Un Lavanda</TD> <TD>783360</TD> <TD>0</TD> <TD>6</TD> <TD>18</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>7055</TD> <TD>Pasta c/Elást. Plast. OF Ref.1021 Cristal</TD> <TD>783360</TD> <TD>0</TD> <TD>5</TD> <TD>40</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>22631</TD> <TD>Desodorizador 360ml Cerejeira de Kyo Secar</TD> <TD>783360</TD> <TD>0</TD> <TD>3</TD> <TD>30</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>18982</TD> <TD>Flanela 38x58 Santa Margarida Laranja</TD> <TD>783360</TD> <TD>0</TD> <TD>3</TD> <TD>25</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>6744</TD> <TD>Pano de Chão Bco Alvejado Grosso 43x65 S.Margarida</TD> <TD>783360</TD> <TD>0</TD> <TD>3</TD> <TD>30</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>24541</TD> <TD>Papel Toalha Interf. 1250Fls New Paper 100%Cel</TD> <TD>783360</TD> <TD>0</TD> <TD>3</TD> <TD>40</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>5559</TD> <TD>Pincel Marca Texto Lumi Color Ref: 200-SL Amarelo</TD> <TD>783360</TD> <TD>0</TD> <TD>3</TD> <TD>12</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>15371</TD> <TD>Fita Plast. 48x50 Ref.PP33TR Transparente</TD> <TD>783360</TD> <TD>0</TD> <TD>2</TD> <TD>12</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>9637</TD> <TD>Limpador Veja Limpeza Pesada X-14 2/1 500ml Cloro</TD> <TD>783360</TD> <TD>0</TD> <TD>2</TD> <TD>12</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>26938</TD> <TD>Máscara Desc. Cirur Tripla c/50 Ref.42018 Cx.Verde</TD> <TD>783360</TD> <TD>0</TD> <TD>2</TD> <TD>12</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>17459</TD> <TD>Papel Sulf. A4 75g/m² 500Fls Branco</TD> <TD>783360</TD> <TD>0</TD> <TD>2</TD> <TD>12</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>21365</TD> <TD>Alcool Gel Antisséptico 70% 5Lt All Clean Audax</TD> <TD>783360</TD> <TD>0</TD> <TD>1</TD> <TD>12</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>24432</TD> <TD>Papel Hig Rolao 8x500 New Paper 100%Cel</TD> <TD>783360</TD> <TD>0</TD> <TD>1</TD> <TD>12</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>16918</TD> <TD>Seven Revest Wax 5Lt Ref.5629</TD> <TD>783360</TD> <TD>0</TD> <TD>1</TD> <TD>12</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>24842</TD> <TD>Vassoura Nylon Cristal Tradic c/Cabo 1,20M c/ Capa</TD> <TD>783360</TD> <TD>0</TD> <TD>1</TD> <TD>12</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>8354</TD> <TD>Envelope 240x340 80g Ref.SKN034/334 Kraft Natural</TD> <TD>736870</TD> <TD>2.000</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>23087</TD> <TD>Fibra Limpeza Macia 100x260mm British Branca</TD> <TD>736198</TD> <TD>2.000</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>20896</TD> <TD>Pincel Marc. Perman. Ref: N450-C Azul</TD> <TD>737282</TD> <TD>1.758</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>14667</TD> <TD>Envelope Plást. 4 Furos 0.20 A4 Ref.020/4F A4</TD> <TD>736979</TD> <TD>1.600</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>26902</TD> <TD>Saco Plást AD 3Kg 24x38x0,03 c/100Un Segplast</TD> <TD>734469</TD> <TD>1.200</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>20677</TD> <TD>Sabonete p/Hotel 20g Alma de Flores</TD> <TD>733468</TD> <TD>1.042</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>14667</TD> <TD>Envelope Plást. 4 Furos 0.20 A4 Ref.020/4F A4</TD> <TD>733485</TD> <TD>1.000</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>14667</TD> <TD>Envelope Plást. 4 Furos 0.20 A4 Ref.020/4F A4</TD> <TD>733999</TD> <TD>1.000</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>15069</TD> <TD>Pano de Chão Bco Alvejado Fino 38x58cm Itatex</TD> <TD>736482</TD> <TD>1.000</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>15678</TD> <TD>Saco p/Lixo 200Lt c/5Un Sacolmax Preto</TD> <TD>734456</TD> <TD>1.000</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>25600</TD> <TD>Envelope Plást. Multiuso 13/11 Furos A4 Ref.1360</TD> <TD>735591</TD> <TD>937</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I need only the sequence 783360 to appear. Hiding the Sequence filter in the column Jan. bringing the correct values of the month Jan.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2022-12-11_08-11-54.jpg" style="width: 881px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/95917i704843E5F97BAA12/image-size/large?v=v2&amp;px=999" role="button" title="2022-12-11_08-11-54.jpg" alt="2022-12-11_08-11-54.jpg" /></span></P> <P>&nbsp;</P> Sun, 11 Dec 2022 12:02:23 GMT https://community.qlik.com/t5/App-Development/Disregard-selected-filter-in-set-analysis/m-p/2015149#M83868 Ribeiro 2022-12-11T12:02:23Z