Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
byrnel0586
Creator
Creator

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

0 Replies