Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

abhijit79008
New Contributor

filter related problem in qlik

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

Tags (2)
6 Replies
Digvijay_Singh
Honored Contributor III

Re: filter related problem in qlik

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

rittermd
Honored Contributor

Re: filter related problem in qlik

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.

abhijit79008
New Contributor

Re: filter related problem in qlik

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

abhijit79008
New Contributor

Re: filter related problem in qlik

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

abhijit79008
New Contributor

Re: filter related problem in qlik

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.

abhijit79008
New Contributor

Re: filter related problem in qlik

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

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

Community Browser