topic ODBC connection - hide columns with no data in QlikView

ODBC connection - hide columns with no data

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: ODBC connection - hide columns with no data

vishsaggi — Mon, 31 Oct 2016 16:30:34 GMT

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;

Re: ODBC connection - hide columns with no data

ift_isabelle — Mon, 31 Oct 2016 16:35:32 GMT

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.

Re: ODBC connection - hide columns with no data

engishfaque — Mon, 31 Oct 2016 18:45:47 GMT

Hi Hasan,

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

Kind regards,

Ishfaque Ahmed