https://community.qlik.com/t5/App-Development/filter-data-is-null/m-p/1887205#M73115 <P>Hello</P> <P>You have to create your Test column as a dimension in the script so that you can filter it.</P> Mon, 31 Jan 2022 16:33:40 GMT MN2 2022-01-31T16:33:40Z https://community.qlik.com/t5/App-Development/filter-data-is-null/m-p/1887192#M73112 <P>hello everybody,<BR />I want data that is zero (no sale) in Vente <STRONG>OR</STRONG> ScnCoin</P> <P><STRONG>(drno is customer)</STRONG></P> <P><BR />#1 data model&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Aubry_0-1643644353703.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/71278iC7DA95CD06404267/image-size/medium?v=v2&amp;px=400" role="button" title="Aubry_0-1643644353703.png" alt="Aubry_0-1643644353703.png" /></span></P> <P>#2 result ok : vente.Mt_vente=Sacancoinventes</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Aubry_1-1643644622653.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/71279i9040F5D77627B6EE/image-size/medium?v=v2&amp;px=400" role="button" title="Aubry_1-1643644622653.png" alt="Aubry_1-1643644622653.png" /></span></P> <P>&nbsp;</P> <P>#3 : without Vente.drno</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Aubry_2-1643644700230.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/71280iAFBC0146A9E2EC8F/image-size/medium?v=v2&amp;px=400" role="button" title="Aubry_2-1643644700230.png" alt="Aubry_2-1643644700230.png" /></span></P> <P>&nbsp;</P> <P>#4 : without Scancoin.dro</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Aubry_3-1643644856885.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/71281iC980F93F86FCC41F/image-size/medium?v=v2&amp;px=400" role="button" title="Aubry_3-1643644856885.png" alt="Aubry_3-1643644856885.png" /></span></P> <P>&nbsp;</P> <P>it's ok it's working well</P> <P><BR /><STRONG>but ... now I want to filter</STRONG></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Aubry_4-1643644926256.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/71282i40B5CD5D662E7D04/image-size/medium?v=v2&amp;px=400" role="button" title="Aubry_4-1643644926256.png" alt="Aubry_4-1643644926256.png" /></span></P> <P>&nbsp;</P> <P>=&gt; it's not working,&nbsp;<BR /><STRONG>the filter does not work<BR /></STRONG>i don't now why<BR /><BR />thx help me :):)<BR /><BR /></P> Mon, 31 Jan 2022 16:05:16 GMT https://community.qlik.com/t5/App-Development/filter-data-is-null/m-p/1887192#M73112 Aubry 2022-01-31T16:05:16Z https://community.qlik.com/t5/App-Development/filter-data-is-null/m-p/1887205#M73115 <P>Hello</P> <P>You have to create your Test column as a dimension in the script so that you can filter it.</P> Mon, 31 Jan 2022 16:33:40 GMT https://community.qlik.com/t5/App-Development/filter-data-is-null/m-p/1887205#M73115 MN2 2022-01-31T16:33:40Z https://community.qlik.com/t5/App-Development/filter-data-is-null/m-p/1887446#M73133 <P>Hello,<BR />first, thank you for your answer,</P> <P>I have two connection&nbsp;<STRONG>different</STRONG> :&nbsp;<BR />#1 ScanCoin</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Aubry_0-1643706081701.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/71322i30ED2C89B5819084/image-size/medium?v=v2&amp;px=400" role="button" title="Aubry_0-1643706081701.png" alt="Aubry_0-1643706081701.png" /></span></P> <P>#2&nbsp; Vente</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Aubry_3-1643706412585.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/71326i8727A4A990973C81/image-size/medium?v=v2&amp;px=400" role="button" title="Aubry_3-1643706412585.png" alt="Aubry_3-1643706412585.png" /></span></P> <P><STRONG>I can't use "resident" function to do column 'testVenteNull'</STRONG></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Aubry_4-1643706537987.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/71327i1200D865749F7C0B/image-size/medium?v=v2&amp;px=400" role="button" title="Aubry_4-1643706537987.png" alt="Aubry_4-1643706537987.png" /></span></P> <P>thank you for help</P> Tue, 01 Feb 2022 09:11:37 GMT https://community.qlik.com/t5/App-Development/filter-data-is-null/m-p/1887446#M73133 Aubry 2022-02-01T09:11:37Z