topic Re: QlikView Set Analysis AND OR Conditions in QlikView

QlikView Set Analysis AND OR Conditions

jyoshna — Wed, 19 Jan 2022 14:03:50 GMT

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)

Re: QlikView Set Analysis AND OR Conditions

marcus_sommer — Thu, 20 Jan 2022 15:31:00 GMT

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

Re: QlikView Set Analysis AND OR Conditions

jyoshna — Fri, 21 Jan 2022 12:20:03 GMT

@marcus_sommer

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

Re: QlikView Set Analysis AND OR Conditions

marcus_sommer — Fri, 21 Jan 2022 12:27:22 GMT

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

Re: QlikView Set Analysis AND OR Conditions

Harvey — Mon, 24 Jan 2022 04:26:57 GMT

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

rapidfs.com

Re: QlikView Set Analysis AND OR Conditions

jyoshna — Mon, 24 Jan 2022 06:22:37 GMT

@marcus_sommer

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