ODBC connection - hide columns with no data

[#1]

Hi all

I have made an ODBC connection and importing data. When clicking "Sheet properties" -> "Fields" and adding all fields, I have some fields which don't contain any data, which I want to hide or dont want to be shown - is this possible?

It consumes much space and don't give me any information at all.

Kind regards

/Inc

[vishsaggi]

What is your data source? Try not to load the fields which are not used in the Load statement like,

IF your DS is SQL or Excel

LOAD col1,

          col2,

          col3;

SQL SElect col1, col2, col3, col4 --Col4 here has no data so not pulling into Qlikview in Load statement.

from dbname;

[ift_isabelle]

If you want to hide lines with no data you can do this:

LOAD col1,

          col2,

          col3

          col4;

SQL SElect col1, col2, col3, col4

from dbname

Where col4 <> '';

This says load colums where colum 4 is not empty.

[engishfaque · Accepted solution]

Hi Hasan,

Do not Load / Select those Fields (Columns) which are not useful for you or for the project.

Kind regards,

Ishfaque Ahmed