topic Re: how to write data script editor when you have multiple filter condition in QlikView

how to write data script editor when you have multiple filter condition

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

if i have two table- Table1 and Table2 and i have filter condition just like as --- Table.1cust_id=123 and Table2.cust_name='Abhijit' or Table1.cust_id<=4567 and Table2.Cust_name='JOHN'.So, in this scenario, how can i write the load script editor into qlik.

Here , i also used Qualify, unqualify Syntax

Qualify*;

Unqualify Product_id;

Load *

From lib://'connection'/Table1.qvd (qvd);

Load *

From lib://'Connection'/Table2.qvd (qvd);

So, my question , where i will use this filter condition.

Re: how to write data script editor when you have multiple filter condition

rajender_qlik — Thu, 15 Feb 2018 19:31:24 GMT

Data_Temp:

Load *

From lib://'connection'/Table1.qvd (qvd);

Concatenate

Load *

From lib://'Connection'/Table2.qvd (qvd);

Store Data_Temp into [lib://'Connection'/Final_Table.qvd](qvd);

Drop table Data_Temp;

Data:

Load *

From [lib://'Connection'/Final_Table.qvd](qvd) where Table.1cust_id=123 and Table2.cust_name='Abhijit' or Table1.cust_id<=4567 and Table2.Cust_name='JOHN';

Re: how to write data script editor when you have multiple filter condition

clondono — Thu, 15 Feb 2018 19:31:37 GMT

Hi Abhijit,

Not sure if I understood your question, but maybe something like this?

Qualify*;

Unqualify Product_id;

Load *

From lib://'connection'/Table1.qvd (qvd)

where cust_id=123 and cust_name='Abhijit';

Load *

From lib://'Connection'/Table2.qvd (qvd)

where cust_id<=4567 and cust_name='JOHN';

Re: how to write data script editor when you have multiple filter condition

Anonymous — Fri, 16 Feb 2018 05:53:00 GMT

Actually, Table1 has so many many values just like as-CUST_ID, PRODUCT_ID, .........ETC

AND Table2 also hold so many values----Cust_name, Product_id,.............etc.

Only, Product_id is common for both table .I want to join two table using this product_id field.That's why i applied qualify syntax to avoid synthetic keys and also unqualify product_id column.

Qualify*;

Unqualify Product_id;

Load *

From lib://'connection'/Table1.qvd (qvd)

where cust_id=123 and cust_name='Abhijit';

Load *

From lib://'Connection'/Table2.qvd (qvd)

where cust_id<=4567 and cust_name='JOHN';

if i applied this syntax--where cust_id=123 and cust_name='Abhijit' into first Table1, i am seeing error mesaage just like as--'''cust_name has not exists into Table1""". So, my question is that, in that case, how can i apply this filter condition

Re: how to write data script editor when you have multiple filter condition

avinashelite — Fri, 16 Feb 2018 06:18:42 GMT

Do you have the column cust_id in table 1 ???? if not you can't refer those columns

share the script , will check and let you know

Re: how to write data script editor when you have multiple filter condition

qlik4asif — Fri, 16 Feb 2018 07:35:32 GMT

Since you have used qualify * before loading table

So now the field cust_id is changed to table.cust_id (here the table is name of ur table

so use table.cust_id in where condition not the cust_id

Load *

From lib://'connection'/Table1.qvd (qvd)

where table.cust_id =123 and table.cust_name='Abhijit';

Re: how to write data script editor when you have multiple filter condition

qlik4asif — Fri, 16 Feb 2018 07:36:20 GMT

or You filter first with where condition and then qualify it.

Re: how to write data script editor when you have multiple filter condition

Anonymous — Fri, 16 Feb 2018 16:01:31 GMT

SELECT * FROM TABLE1 ,TABLE2,TABLE3

WHERE

TABLE1.PRODUCT_KEY=TABLE3.PRODUCT_KRY

AND

TABLE2.PRODUCT_PART.NO.=TABLE3.PRODUCT_PART_NO.

AND

( TABLE1.INTP_TYPE in ('i', 's', 'c') and TABLE2.PRODUCT _PART_NO<> '20398'

or TABLE1.INTP_TYPE in ('s', 'd')

and TABLE2.PRODUCT_PART_NO.= '20398' );

SO, my question is that, ewhere i will use this filter condition.----

TABLE1.INTP_TYPE in ('i', 's', 'c') and TABLE2.PRODUCT _PART_NO<> '20398'

or TABLE1.INTP_TYPE in ('s', 'd')

and TABLE2.PRODUCT_PART_NO.= '20398

Re: how to write data script editor when you have multiple filter condition

Anonymous — Fri, 16 Feb 2018 18:16:50 GMT

SELECT * FROM TABLE1 ,TABLE2,TABLE3

WHERE

TABLE1.PRODUCT_KEY=TABLE3.PRODUCT_KRY

AND

TABLE2.PRODUCT_PART.NO.=TABLE3.PRODUCT_PART_NO.

AND

( TABLE1.INTP_TYPE in ('i', 's', 'c') and TABLE2.PRODUCT _PART_NO<> '20398'

or TABLE1.INTP_TYPE in ('s', 'd')

and TABLE2.PRODUCT_PART_NO.= '20398' );

---------this is my script

I am telling you the original scenario:----

Load PRODUCT_KEY from

table.qvd;

load PRODUCT_PART_NO, PRODUCT_KEY from

table3.qvd;

Load PRODUCT_PART.NO from

table2.qvd;

Now, where i will use this condition, If , i use this filter condition ----

(TABLE1.INTP_TYPE in ('i', 's', 'c') and TABLE2.PRODUCT _PART_NO<> '20398'

or TABLE1.INTP_TYPE in ('s', 'd')

nd TABLE2.PRODUCT_PART_NO.= '20398')

Re: how to write data script editor when you have multiple filter condition

Anonymous — Fri, 16 Feb 2018 18:21:12 GMT

SELECT * FROM TABLE1 ,TABLE2,TABLE3

WHERE

TABLE1.PRODUCT_KEY=TABLE3.PRODUCT_KRY

AND

TABLE2.PRODUCT_PART.NO.=TABLE3.PRODUCT_PART_NO.

AND

( TABLE1.INTP_TYPE in ('i', 's', 'c') and TABLE2.PRODUCT _PART_NO<> '20398'

or TABLE1.INTP_TYPE in ('s', 'd')

and TABLE2.PRODUCT_PART_NO.= '20398' );

---------this is my script

I am telling you the original scenario:----

Load PRODUCT_KEY from

table.qvd;

load PRODUCT_PART_NO, PRODUCT_KEY from

table3.qvd;

Load PRODUCT_PART.NO from

table2.qvd;

Now, where i will use this condition, If , i use this filter condition ----

(TABLE1.INTP_TYPE in ('i', 's', 'c') and TABLE2.PRODUCT _PART_NO<> '20398'

or TABLE1.INTP_TYPE in ('s', 'd')

nd TABLE2.PRODUCT_PART_NO.= '20398')

into sheet, in that tell me the exact field expression?

I have PRODUCT_PART_NO. into my sheet, can i apply this filter expression in this column?