Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
FedeCata
New Contributor

Load From SQL Server Fail

Good Morning

I'm having a problem with the loading of some data from SQL server, here the query:

LOAD

field1,
field2,
field3,
field4,
field5;

[Table Name]:
SELECT

field1, 
field2
field3
field4
field5
FROM Table WHERE field5 is not null;

 

If i visualize the table i can found all the field with field5 value NULL.

 

If from GUI i select "hide null value" the data disappear 

 

Thank you

3 Replies
Highlighted
Umesh
New Contributor III

Re: Load From SQL Server Fail

Hi
Qlikview have an Option in presentation layer to "Hide Null Value " based in the Field added in Dimension , since load table in the script is combination of subset for 5 fields in 1 table
You can check the CTRL + T ( table viewer) .

LOAD id, first_name, last_name, email, gender, City, [Purchase Date], [Car Model]
FROM [..\Downloads\MOCK_DATA.csv] (txt, utf8, embedded labels, delimiter is ',', msq)
WHERE(not IsNull([Purchase Date]));
jyothish8807
Honored Contributor II

Re: Load From SQL Server Fail

Hi Feda,

You can try like this as well, but you have to be careful while putting a 'where' condition since it might omit relevant information from other fields.

LOAD

field1,
field2,
field3,
field4,
field5;

[Table Name]:
SELECT

field1, 
field2
field3
field4
field5
FROM Table

WHERE len(trim(field5))>0;

Best Regards,
KC

Re: Load From SQL Server Fail

If you run your select query against your database directly, not from QlikView, do you get records returned with NULL values in field5?

SELECT field1,  field2field3,  field4,  field5
FROM Table WHERE field5 is not null;

Community Browser