topic Mixing AND and OR conditions in Set Analysis in QlikView

Mixing AND and OR conditions in Set Analysis

lsteere01 — Thu, 08 May 2014 19:35:41 GMT

I need to do a set analysis with the following logic:

(INPATIENT_VISIT={1} or OBSERVATION_VISIT={1}) and (DISCH_GAP_CHART_LOOKBACK_INCLUDE={1})

I've trid the following but it dosn't work:

Median({1<INPATIENT_VISIT={1}> + <OBSERVATION_VISIT={1}>, <DISCH_GAP_CHART_LOOKBACK_INCLUDE={1}>} IPOB)

Any help would be appreciated.

Thanks.

Thu, 08 May 2014 19:40:47 GMT

Maybe this:

Median({1<INPATIENT_VISIT={1}> + <OBSERVATION_VISIT={1} , DISCH_GAP_CHART_LOOKBACK_INCLUDE={1}>} IPOB)

Thu, 08 May 2014 19:44:34 GMT

Update i didn't notice your brackets around OR so I think this should serve the purpose

Median({1<INPATIENT_VISIT={1} , DISCH_GAP_CHART_LOOKBACK_INCLUDE={1}> +

<OBSERVATION_VISIT={1}, DISCH_GAP_CHART_LOOKBACK_INCLUDE={1}>} IPOB)

lsteere01 — Thu, 08 May 2014 19:48:33 GMT

That works. Thanks!