https://community.qlik.com/t5/QlikView/how-not-to-get-empty-data-from-tables/m-p/1838528#M1215101 <P>HI</P><P>how not to retrieve data that are empty in a table in a script</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Luke_Killer_IT_0-1632378485212.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/62609i667133EFF2DA5B95/image-size/medium?v=v2&amp;px=400" role="button" title="Luke_Killer_IT_0-1632378485212.png" alt="Luke_Killer_IT_0-1632378485212.png" /></span></P><P>&nbsp;</P> Thu, 23 Sep 2021 06:28:11 GMT Luke_Killer_IT 2021-09-23T06:28:11Z https://community.qlik.com/t5/QlikView/how-not-to-get-empty-data-from-tables/m-p/1838528#M1215101 <P>HI</P><P>how not to retrieve data that are empty in a table in a script</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Luke_Killer_IT_0-1632378485212.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/62609i667133EFF2DA5B95/image-size/medium?v=v2&amp;px=400" role="button" title="Luke_Killer_IT_0-1632378485212.png" alt="Luke_Killer_IT_0-1632378485212.png" /></span></P><P>&nbsp;</P> Thu, 23 Sep 2021 06:28:11 GMT https://community.qlik.com/t5/QlikView/how-not-to-get-empty-data-from-tables/m-p/1838528#M1215101 Luke_Killer_IT 2021-09-23T06:28:11Z https://community.qlik.com/t5/QlikView/how-not-to-get-empty-data-from-tables/m-p/1838541#M1215103 <P>Hello,</P><P>In the script write the statement below:</P><P><EM>Where Len([your field]) &gt; 0</EM></P> Thu, 23 Sep 2021 06:50:51 GMT https://community.qlik.com/t5/QlikView/how-not-to-get-empty-data-from-tables/m-p/1838541#M1215103 MindaugasBacius 2021-09-23T06:50:51Z https://community.qlik.com/t5/QlikView/how-not-to-get-empty-data-from-tables/m-p/1838563#M1215110 <P>Thanks it works</P> Thu, 23 Sep 2021 07:44:22 GMT https://community.qlik.com/t5/QlikView/how-not-to-get-empty-data-from-tables/m-p/1838563#M1215110 Luke_Killer_IT 2021-09-23T07:44:22Z