QlikView Set Analysis AND OR Conditions

[jyoshna]

HI

Can someone help me with set expression for below

Sum(sales)
WHERE exclusion_category = 'Exception' 
AND SEGMENT = 'Banking' 
AND
(mrkr_set = 'Y'
or offset_ind='Y'
or dbt_ind='Y'
or actv_acct='Y'
or mgmt_ind = 'Y'
or refer_mrkr=0
)

 written expression like below , didn't get the desired results

sum({<exclusion_category={'Exception'},SEGMENT={'Banking'}> *
<mrkr_set_S={'Y'}> + <offset_ind={'Y'}> + <dbt_ind={'Y'}> + <actv_acct={'Y'}> + <mgmt_ind={'Y'}> + <refer_mrkr={'0'}>}sales)

[marcus_sommer]

Try it in this way:

sum({<exclusion_category={'Exception'},SEGMENT={'Banking'}> *
           (<mrkr_set_S={'Y'}> + <offset_ind={'Y'}> + <dbt_ind={'Y'}> +
           <actv_acct={'Y'}> + <mgmt_ind={'Y'}> + <refer_mrkr={'0'})>} sales)

- Marcus

[jyoshna]

@marcus_sommer 

Expression is not accepting () , expression error . Can you suggest please .

[marcus_sommer]

The last bracket is wrong. Try this again:

sum({<exclusion_category={'Exception'},SEGMENT={'Banking'}> *
           (<mrkr_set_S={'Y'}> + <offset_ind={'Y'}> + <dbt_ind={'Y'}> +
           <actv_acct={'Y'}> + <mgmt_ind={'Y'}> + <refer_mrkr={'0'}>)} sales)

- Marcus

[Harvey]

Hey can you please suggest me the answer i got the same issue and still finding the solution thanks in advance.

rapidfs.com

[jyoshna]

@marcus_sommer 

Thank You , now there is no syntax error , i will validate the data and respond you back .