Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

filtering out NULL

this is the out put

I need to not show the blanks  I am doing a direct connect so the filter is cluttered

example of other data

[Facilities]:
LIB CONNECT TO [pmd-sandbox (pharmore_rwinkel)];
LOAD [FacID],
[FacName];
SQL SELECT  "FacID",
  "FacName"
FROM "Fac"."dbo"."Facilities";


[FacilityCustomFields]:
LIB CONNECT TO [pmd-sandbox (pharmore_rwinkel)];
LOAD [FacID],
[CFID],
[CFValue];
SQL SELECT  "FacID",
  "CFID",
  "CFValue"
FROM "Fac"."dbo"."FacilityCustomFields";
THis is where I am trying to remove the blanks   WHERE CFValue IS NOT Null

[CustomFieldDefs]:
LIB CONNECT TO [pmd-sandbox (pharmore_rwinkel)];
LOAD [CFName],
[CFID];
SQL SELECT  "CFName",
  "CFID"
FROM "FwLTC"."dbo"."CustomFieldDefs"
I added this to filter down to just two descriptions in field heading  WHERE CFName = 'v2016 (MM-DD-YY)' or CFName = 'v2016 Clarification Needed';

1 Solution

Accepted Solutions
bellamae
Valued Contributor

Re: filtering out NULL

Your semicolon is before the where statement it needs to be after it.

6 Replies
bellamae
Valued Contributor

Re: filtering out NULL

I personally would use

Where  len(CFValue)>0

but there will be other ways to achieve it.

Not applicable

Re: filtering out NULL

Did I miss something?  see row 19

.

bellamae
Valued Contributor

Re: filtering out NULL

Your semicolon is before the where statement it needs to be after it.

Not applicable

Re: filtering out NULL

bellamae
Valued Contributor

Re: filtering out NULL

FROM "Fac"."dbo"."FacilityCustomFields"
WHERE len(CFValue)>0;

Only one semicolon.

Re: filtering out NULL

I think you are trying to put a QlikView syntax in SQL Statement, I would suggest using a SQL syntax to restrict, but in QlikView you can restrict in the preceding load....

LOAD *

Where Len(Trim(CFValue)) > 0;

SQL  SELECT

*

FROM ....

Community Browser