topic Re: Set analysis with multiple AND,OR conditions in QlikView

Set analysis with multiple AND,OR conditions

Tue, 25 Nov 2014 15:11:46 GMT

There are several "OR" and "AND" condition in my set analysis. The below code is not providing the correct results. What am I missing? Any help you can provide is appreciated. Thanks!

CRITERIA:

Based on the current user selection count distinct CSN_ID's if the following condition is met:

Either HK7959 OR OFF_HK7959 has a value of 'Y'

AND

Either HK8017 OR OFF_HK8017 has a value of 'Y'

AND

Either HK8020 OR OFF_HK8020 has a value of 'Y'

AND

Either HK8024 OR OFF_HK8024 has a value of 'Y'

AND

Either HK8032 OR OFF_HK8032 has a value of 'Y'

AND

Either HIP2111 OR OFF_HIP2111 has a value of 'Y'

({$<HK7959={'Y'}>+<OFF_HK7959={'Y'}>*<HK8017={'Y'}>+<OFF_HK8017={'Y'}>*<HK8020={'Y'}>+<OFF_HK8020={'Y'}>*<HK8024={'Y'}>+<OFF_HK8024={'Y'}>*<HK8032={'Y'}>+<OFF_HK8032={'Y'}>*<HIP2111={'Y'}>+<OFF_HIP2111={'Y'}> }DISTINCT CSN_ID)

Re: Set analysis with multiple AND,OR conditions

JonnyPoole — Tue, 25 Nov 2014 15:17:35 GMT

Silly question... have you considered creating this as calculated field in the load script ?

Re: Set analysis with multiple AND,OR conditions

Peter_Cammaert — Tue, 25 Nov 2014 23:56:50 GMT

Use parentheses to group the union sets and give them precedence over the intersection sets, like in

...{(Set_A + Set_B) * (Set_C + Set_D) * (Set_E...}...

Best,

Peter

Re: Set analysis with multiple AND,OR conditions

Wed, 26 Nov 2014 15:04:33 GMT

Thanks!