QLIK Object incorrectly calculating Expression

sharynwhite — Wed, 16 Jan 2019 21:42:33 GMT

I created a calculated expression called Net Amount in my Qlik Object. In my calculation, I had to hard code in a dollar amount for accounting purposes. In the Qlik Object,The sum of my calculation does not equal my hard coding additions; however, when I export the same data to Excel (without changing anything), the sum in Excel is accurate.

I am getting two different numbers based on the same logic and same data, just different format (Excel export vs Qlik) .

Below is my logic ( note: I replaced account number with '########':

if([Account Number]='########','16630.88',

if([Account Number]= '########','27479.21',

if([Account Number]= '########','10104.76', I

f([Account Number]= '########','14105.80',

if([Account Number]= '########','21539.26',

if([Account Number]= '########','49515.28',

if([Account Number]= '########','4165.01',

if([Account Number]= '########','7344.20',

if([Account Number]= '########','14559.19',

if([Account Number]= '########','31985.66',

if([Account Number]= '########','59616.58',

if([Account Number]= '########','25750.54',

if([Account Number]= '########','10029.85',

if([Account Number]= '########','6795.16',

if([Account Number]= '########','6299.54',

if([Account Number]= '########','29263.95',

if([Account Number]= '########','5663.27',

if([Account Number]= '########','26439.93',

if([Account Number]= '########','9650.02',

if([Account Number]= '########','-489.54',

if([Account Number]= '########','42347.82',

if([Account Number]= '########','9986.49',

if([Account Number]= '########','9527.98',

if([Account Number]= '########','-2621.51',

if([Account Number]= '########','44766.83',

if([Account Number]= '########','24791.13',

if([Account Number]= '########','41405.90',

if([Account Number]= '########','66050.60',

if([Account Number]= '########','6730.27',

if([Account Number]= '########','1315.59',

if([Account Number] = '########', '-632.06',

if([Application Type]='IL' or [Application Type]='ML', Sum([Principal - Participated]) - Sum(UNEARN_DEFER_FEES_AMT)- sum(UNEARNED_DEFER_FEES_AMT) + sum(REMAIN_DEFER_FEES_AMT)+sum ([Defer_fee_bal_amt])+sum (Defer_cost_bal_amt) , sum([Net Loan Balance]) - Sum(UNEARN_DEFER_FEES_AMT)- sum(UNEARNED_DEFER_FEES_AMT) + sum(REMAIN_DEFER_FEES_AMT)-sum ([Defer_fee_bal_amt])+sum (Defer_cost_bal_amt), ))))))))))))))))))))))))))))))))

topic QLIK Object incorrectly calculating Expression in QlikView

QLIK Object incorrectly calculating Expression