Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
abhijit79008
New Contributor

Filtering Issue

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 )

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