Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I had to hard code in account numbers and their respective balances into my Qlik object Expression, for accounting reasons. However, my object does not sum correctly. When I export the same object to Excel and sum the same data- it does sum to the correct amount. HOW CAN I GET TO SUM CORRECLTY IN MY QLIK OBJECT (SEE ATTACHED EXAMPLE)?
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 used in Qlik ( NOTE: I substituted account numbers with '######' 😞
if([Account Number]='######',sum(16630.88),
if([Account Number]= '######’,sum(27479.21),
if([Account Number]= '######',sum(10104.76),
if([Account Number]= '######',sum(14105.80),
if([Account Number]= '######',sum(21539.26),
if([Account Number]= '######',sum(49515.28),
if([Account Number]= '######',sum(4165.01),
if([Account Number]= '######',sum(7344.20),
if([Account Number]= '######',sum(14559.19),
if([Account Number]= '######’,sum(31985.66),
if([Account Number]= '######’,sum(59616.58),
if([Account Number]= '######',sum(25750.54),
if([Account Number]= '######',sum(10029.85),
if([Account Number]= '######',sum(6795.16),
if([Account Number]=''######',sum(6299.54),
if([Account Number]= '######',sum(29263.95),
if([Account Number]= '######',sum(5663.27),
if([Account Number]= '######’,sum(26439.93),
if([Account Number]= '######',sum(9650.02),
if([Account Number]= '######',sum(-489.54),
if([Account Number]= '######',sum(42347.82),
if([Account Number]= '######',sum(9986.49),
if([Account Number]= '######’,sum(9527.98),
if([Account Number]= '######’,sum(-2621.51),
if([Account Number]=''######’,sum(44766.83),
if([Account Number]= '######’,sum(24791.13),
if([Account Number]= '######',sum(41405.90),
if([Account Number]= '######',sum(66050.60),
if([Account Number]= '######',sum(6730.27),
if([Account Number]= '######',sum(1315.59),
if([Account Number] = '######', sum(-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) ))))))))))))))))))))))))))))))))
What happens when you wrap your expression with Sum(Aggr()) function
Sum(Aggr( if([Account Number]='######',sum(16630.88), if([Account Number]= '######’,sum(27479.21), if([Account Number]= '######',sum(10104.76), if([Account Number]= '######',sum(14105.80), if([Account Number]= '######',sum(21539.26), if([Account Number]= '######',sum(49515.28), if([Account Number]= '######',sum(4165.01), if([Account Number]= '######',sum(7344.20), if([Account Number]= '######',sum(14559.19), if([Account Number]= '######’,sum(31985.66), if([Account Number]= '######’,sum(59616.58), if([Account Number]= '######',sum(25750.54), if([Account Number]= '######',sum(10029.85), if([Account Number]= '######',sum(6795.16), if([Account Number]=''######',sum(6299.54), if([Account Number]= '######',sum(29263.95), if([Account Number]= '######',sum(5663.27), if([Account Number]= '######’,sum(26439.93), if([Account Number]= '######',sum(9650.02), if([Account Number]= '######',sum(-489.54), if([Account Number]= '######',sum(42347.82), if([Account Number]= '######',sum(9986.49), if([Account Number]= '######’,sum(9527.98), if([Account Number]= '######’,sum(-2621.51), if([Account Number]=''######’,sum(44766.83), if([Account Number]= '######’,sum(24791.13), if([Account Number]= '######',sum(41405.90), if([Account Number]= '######',sum(66050.60), if([Account Number]= '######',sum(6730.27), if([Account Number]= '######',sum(1315.59), if([Account Number] = '######', sum(-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) )))))))))))))))))))))))))))))))) , [RECON#]))
Close, This gives me all $0's now.