Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
karthikoffi27se
Creator III
Creator III

Total value doesn't match

I am trying to calculate burning cost, I need the split up of my expression total. my total is showing 7465 but my rows are showing  

Inpatient - 1280564

Outpatient - 8281

Here is the expression i used 

(sum( {<CLAIM_FLAG={'CLAIMS'},CHECK_PAIDAMT={'1'},POLICY_FLAG={'POLICY'},TREAT_FROM_NUM={'<=$(=vLRason)'}>}PAIDAMT)
+
((sum( {<CLAIM_FLAG={'CLAIMS'},CHECK_PAIDAMT={'1'},POLICY_FLAG={'POLICY'},TREAT_FROM_NUM={'<=$(=vLRason)'}>}PAIDAMT)*vIBNR)/100)
)
/
SUM({<POLICY_FLAG={'POLICY'}>}AGGR((IF(RANGEMIN((TERMINATION_DATE+1),vLRason,(TO_DATE))-(EFFECTIVE_FROM)>0,


Interval(RANGEMIN((TERMINATION_DATE+1),vLRason+1,(TO_DATE))-(EFFECTIVE_FROM))/ ((TO_DATE)-FROM_DATE)
,0)),%MEMBER_POLICY_KEY,MEMBERID))

 

Can you please guide me to get the expression total ie I need the split up of 7465 for both inpatient and outpatient.

Thanks in advance

Karthik

Labels (1)
0 Replies