Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
byrnel0586
Contributor

Set Analysis w/ Multiple Conditions

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])