filter related problem in qlik

[Anonymous]

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, where 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

[Digvijay_Singh]

Are you facing any problem if you use this as it is in the script load statement?

[rittermd]

Since this is your load script that is the only data that will make it into your app.

If you then added filters for those fields on a sheet you would only see the values that you selected in the Where clause.

[Anonymous]

Yes, actually, this is not single filter condition .

I am telling you the original scenario.

Load   PRODUCT_KEY from

table.qvd;

i

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')

and TABLE2.PRODUCT_PART_NO.= '20398')

[Anonymous]

I am telling you the original scenario.

Load   PRODUCT_KEY from

table.qvd;

i

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')

and TABLE2.PRODUCT_PART_NO.= '20398')

[Anonymous]

I am telling you the original scenario.

Load   PRODUCT_KEY from

table.qvd;

i

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')

and TABLE2.PRODUCT_PART_NO.= '20398')

So, you are saying that, i have to use this condition into sheet.

IN that case, i have product_part_number column into my app sheet, so how can i write the fileld expression into this particular column.---PRODUCT_PART_NO.

[Anonymous]

can i use this expression:------

if(match(invc_flag,'i','s','c') or  NOT match(invc_flag,'s','d'),product_part_no.,'20398')