Set Analysis w/ Multiple Conditions

byrnel0586 — Thu, 23 May 2019 13:25:35 GMT

Hi all,

I have looked at other posts related to my question but have had no luck finding an answer. Any help is appreciated.

I have a calculation that counts all approved claims for all months greater than the one selected.

However, I need to only count the approved claims when the claim was denied in the month selected.

For example: WHEN [DETRMN_DISPOSITION] = 'Denied' FOR Only([DETRMN_RPT_MTH_DATE_SKEY]) THEN count({$<[DETRMN_DISPOSITION]={'Approved'},[DETRMN_RPT_MTH_DATE_SKEY]={">$(=Only([DETRMN_RPT_MTH_DATE_SKEY]))"}>} [DETRMN_AUTH_CLAIM_NBR])

This is the formula I am using now but am getting all approvals regardless if it was denied.

=count({$<[DETRMN_DISPOSITION]={'Approved'},[DETRMN_RPT_MTH_DATE_SKEY]={">$(=Only([DETRMN_RPT_MTH_DATE_SKEY]))"}>} [DETRMN_AUTH_CLAIM_NBR])

topic Set Analysis w/ Multiple Conditions in QlikView

Set Analysis w/ Multiple Conditions