Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I am trying to execute a where command in the Qlikview script to restrict the data which is loaded in from an Excel spreadsheet. It works fine when I put in the first greater than date, but fails when I need to put in the greater than OR blank value for the date field.
i.e.. I am looking to get the data set to be the workers which joined in the UK; from these workers their join date of first of Jan 2017 or their join date is blank.
my code which works fine is:
Load ....
[Employees]
[Join Date]
from....
where ([Employees] = 'UK' And [Join Date] >= '01/01/2017');
my code which fails when I also need the blank values
Load ....
[Employees]
[Join Date]
from....
where ([Employees] = 'UK' And ([Join Date] >= '01/01/2017' Or [Join Date] = ' '));
I am not sure if this is a syntax issue or the blanks are not being recognised as the total value does not increase, even though I know there is a large quantity of blanks to be counted.
Any help appreciated
Your Code is looking fine. May be try the alternate way
where [Employees] = 'UK' And ([Join Date] >= '01/01/2017' Or Len(Trim([Join Date]))=0);
Your Code is looking fine. May be try the alternate way
where [Employees] = 'UK' And ([Join Date] >= '01/01/2017' Or Len(Trim([Join Date]))=0);
That's sorted it, many thanks for your quick response.