topic Re: How to exclude values from table in load statement in QlikView

How to exclude values from table in load statement

Mon, 29 Oct 2012 13:54:25 GMT

Hello,

I am trying to load a table to QV but exclude rows where column A = 'X'. What is the syntax for this? I thought I could just add a WHERE statement but can't find the correct way to do this. Here is my code currently:

SQL

SELECT *
FROM CIA.dbo."CU_Prem_Mbrship";

Let me know if that is not clear. Thanks.

Craig

Re: How to exclude values from table in load statement

MayilVahanan — Mon, 29 Oct 2012 13:59:51 GMT

Table1:

Load *;

SQL

SELECT *
FROM CIA.dbo."CU_Prem_Mbrship" where A = 'X';

Then store inqvd;

Store Table1 into TableName.qvd(qvd);

Then use qvd.. Because inorder to avoid the connect the database for every time. For qvd , its easy to load when compare to sql connection(data retrieval).

Re: How to exclude values from table in load statement

jagan — Mon, 29 Oct 2012 14:07:56 GMT

Hi,

You can straight away use where condition in SQL query. Please check below query

TableName:

SQL SELECT *
FROM CIA.dbo."CU_Prem_Mbrship"

where A = 'X';

Hope this helps you.

Regards,

Jagan.

Re: How to exclude values from table in load statement

Mon, 29 Oct 2012 14:09:45 GMT

How do you do A NOT = 'X'?

Thanks

Re: How to exclude values from table in load statement

haymarketpaul — Mon, 29 Oct 2012 14:15:41 GMT

Where A <> 'X'

Re: How to exclude values from table in load statement

jagan — Mon, 29 Oct 2012 14:18:07 GMT

Hi,

Try like this

where A <> 'X'

Regards,

Jagan.

Re: How to exclude values from table in load statement

MayilVahanan — Mon, 29 Oct 2012 15:22:12 GMT

Try like this

SQL

SELECT *
FROM CIA.dbo."CU_Prem_Mbrship" where A <> 'X';

Hope it helps

Re: How to exclude values from table in load statement

Mon, 29 Oct 2012 15:51:42 GMT

Hi Mayil,

I have the where statement figured out but still trying to understand why you advocate saving my tables as qvd. Will this improve processing time within the application (pivot table calculations when filtering)? Will this save space?

Thanks

Re: How to exclude values from table in load statement

MayilVahanan — Mon, 29 Oct 2012 15:56:24 GMT

By using connection string, every time data fetch from database(sql). so its take time to load the data when compare to qvd. So only i mentioned like that..

Hope attached file helps you to understand about qvd.