Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

MULTIPLE FILTER CONDITION

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

5 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable
Author

i am using qlik sense, not qlik view.

In that case, how can i write this expression.

jonathandienst
Partner - Champion III
Partner - Champion III

Qlikview and Qliksense expressions work the same way.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable
Author

I have to write this expression into field