MULTIPLE FILTER CONDITION

[Anonymous]

SELECT * FROM

Table 1,

Table 2

where

(

Table2."PRODUCT_CODE" in ('400', '500', '600')

and

"Table 1"."AMOUNT_FLAG" in ('s', 'd')

and

case  when ("Table 1"."AMOUNT_TYP" in ('Credit', 'Debit')) then "Table 1".AMOUNT else 0 end  <> 0

or

"Table2"."PRODUCT_CODE" in ('600', '410')

and

"Table 1"."AMOUNT_FLAG" in ('i', 'c', 's')

and

"Table2"."PRODUCT_NUM" <> '203'

or

"Table2"."PRODUCT_NUM" = '203'

and

"Table1"."AMOUNT_FLAG" in ('s', 'd')

and

case  when ("Table 1"."AMOUNT_TYP" in ('Credit', 'Debit')) then "Table 1"."AMOUNT" else 0 end  <> 0 )

-----This is my query .So, my question is that how can i write this filter condition into load script editor ??

----can i handle this filter into sheet ??

----tell me the exact expression for this filter condition

[jonathandienst]

-----This is my query .So, my question is that how can i write this filter condition into load script editor ??

Why? If it works in SQL, leave it there.

----can i handle this filter into sheet ??

The set expression are a little complex. I will add it in a minute or two

----tell me the exact expression for this filter condition

Here to answer that given that we have no filed names other than those in the filter.

[jonathandienst]

Set expression like this, perhaps?

{<PRODUCT_CODE = {'400', '500', '600'},

AMOUNT_FLAG = {'s', 'd'},

AMOUNT_TYP" = {'Credit', 'Debit'},

AMOUNT -= {'0'}>

+

<PRODUCT_CODE = {'600', '410'},

AMOUNT_FLAG = {'i', 'c', 's'},

PRODUCT_NUM -= {'203'}>

+

<PRODUCT_NUM = {'203'},

AMOUNT_FLAG = {'s', 'd'},

AMOUNT_TYP" = {'Credit', 'Debit'},

AMOUNT -= {'0'}>}

[Anonymous]

i am using qlik sense, not qlik view.

In that case, how can i write this expression.

[jonathandienst]

Qlikview and Qliksense expressions work the same way.

[Anonymous]

I have to write this expression into field