Filtering Issue

Anonymous — Tue, 06 Mar 2018 07:14:39 GMT

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

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

and

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

and

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

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

-----Now,my question is that how can i write this filter condition into load script editor or report sheet??

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

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

topic Filtering Issue in QlikView