topic Qvd filter in QlikView https://community.qlik.com/t5/QlikView/Qvd-filter/m-p/386484#M1161853 <HTML><HEAD></HEAD><BODY><P>I am Loading a QVD file.....I have one field which hass null values....I want to load qvd for values whre that field is not null........</P><P></P><P>ex :-</P><P></P><P>load </P><P></P><P>qvd</P><P></P><P>where field is not null</P><P></P><P>Please help me how can I give where condition.......</P></BODY></HTML> Wed, 28 Nov 2012 15:25:41 GMT 2012-11-28T15:25:41Z Qvd filter https://community.qlik.com/t5/QlikView/Qvd-filter/m-p/386484#M1161853 <HTML><HEAD></HEAD><BODY><P>I am Loading a QVD file.....I have one field which hass null values....I want to load qvd for values whre that field is not null........</P><P></P><P>ex :-</P><P></P><P>load </P><P></P><P>qvd</P><P></P><P>where field is not null</P><P></P><P>Please help me how can I give where condition.......</P></BODY></HTML> Wed, 28 Nov 2012 15:25:41 GMT https://community.qlik.com/t5/QlikView/Qvd-filter/m-p/386484#M1161853 2012-11-28T15:25:41Z Re: Qvd filter https://community.qlik.com/t5/QlikView/Qvd-filter/m-p/386485#M1161854 <HTML><HEAD></HEAD><BODY><P>I got it...</P><P></P><P>where len(Field)&gt;0</P></BODY></HTML> Wed, 28 Nov 2012 15:37:49 GMT https://community.qlik.com/t5/QlikView/Qvd-filter/m-p/386485#M1161854 2012-11-28T15:37:49Z Re: Qvd filter https://community.qlik.com/t5/QlikView/Qvd-filter/m-p/2453580#M1225703 <P>Hi,</P> <P>and for the opposite? Only where the value is NULL?</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Zeta_0-1715940898783.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/166312i432B1C648CC02DDB/image-size/medium?v=v2&amp;px=400" role="button" title="Zeta_0-1715940898783.png" alt="Zeta_0-1715940898783.png" /></span></P> <P>&nbsp;</P> <P>Thx for help</P> Fri, 17 May 2024 10:15:24 GMT https://community.qlik.com/t5/QlikView/Qvd-filter/m-p/2453580#M1225703 Zeta 2024-05-17T10:15:24Z Re: Qvd filter https://community.qlik.com/t5/QlikView/Qvd-filter/m-p/2453584#M1225704 <P>Hi <a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/131586">@Zeta</a>&nbsp;- just use Data Load editor (Instead of Data Manager which is very limited) and put a were clause directly there:</P> <UL> <LI>Where Len(Trim(YourField))=0</LI> <LI>or Isnull(YourField)</LI> </UL> Fri, 17 May 2024 10:30:47 GMT https://community.qlik.com/t5/QlikView/Qvd-filter/m-p/2453584#M1225704 Lech_Miszkiewicz 2024-05-17T10:30:47Z