Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sammo
Contributor
Contributor

Load Fields where a Field is empty (has no value)

Hello Community

I have a question about loading a qvd-File like this:

Load
  ID,
  Name, 
  Surname, 
  Birthdate, 
  Address, 
  City
FROM Adresses.qvd
WHERE Birthdate > then date('01.01.1950', 'dd.mm.yyyy') OR Birthdate = '';

So i want to load all de rows where the birthdate is higher than 1950 and all the rows which have an empty birthdate-field. 

the bigger than works fine, but the rows with the empty birthdates are not in the resulting dataset.

any ideas? 

thank you very much!

Labels (5)
1 Solution

Accepted Solutions
Anil_Babu_Samineni

If your date format is the valid, U can try

Load
  ID,
  Name, 
  Surname, 
  Birthdate, 
  Address, 
  City
FROM Adresses.qvd
WHERE Year(Birthdate) > 1950 or IsNull(Birthdate);

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

1 Reply
Anil_Babu_Samineni

If your date format is the valid, U can try

Load
  ID,
  Name, 
  Surname, 
  Birthdate, 
  Address, 
  City
FROM Adresses.qvd
WHERE Year(Birthdate) > 1950 or IsNull(Birthdate);

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)