Problem with expression in a straight table some figures incorrect

qlikmpate0 — Tue, 06 Mar 2018 10:19:15 GMT

I have this calculation in my straight table, all rows are calculating the correct figure except three rows highlighted

My expression is this for avail credit line column, I have also attached the settings from chart properties.

(Sum([Credit Limit])

((Sum({<[OEL On Hold]={'Y'}, [OEL Credit Hold]={'N'}, OE_Order_Lines_All.INVOICE_INTERFACE_STATUS_CODE-={'YES'}>

<[OEL On Hold]={'N'}, OE_Order_Lines_All.INVOICE_INTERFACE_STATUS_CODE-={'YES'}>}

If([Line Calc Tax Rate]>0,

OE_Order_Lines_All.ORDERED_QUANTITY * OE_Order_Lines_All.UNIT_SELLING_PRICE*((100+[Line Calc Tax Rate])/100),

OE_Order_Lines_All.ORDERED_QUANTITY * OE_Order_Lines_All.UNIT_SELLING_PRICE)

)

Sum({<[OEL On Hold]={'Y'}, [OEL Credit Hold]={'N'}, OE_Order_Lines_All.INVOICE_INTERFACE_STATUS_CODE-={'YES'}>

<[OEL On Hold]={'N'}, OE_Order_Lines_All.INVOICE_INTERFACE_STATUS_CODE-={'YES'}>}

[Freight Amount])

)

(Sum([Acctd Amount Due Remaining])-Sum(Alt(AR_Receivable_Applications_All.AMOUNT_APPLIED,0)))))/1000

Re: Problem with expression in a straight table some figures incorrect

marcus_sommer — Tue, 06 Mar 2018 11:54:59 GMT

Try it with a range-function for adding the various expression-parts, like:

rangesum(sum1, sum2, sum3, -sum4)

- Marcus

Re: Problem with expression in a straight table some figures incorrect

qlikmpate0 — Tue, 06 Mar 2018 11:59:37 GMT

Thank you Marcus, I figured out why it wasn't working for the highlighted figures, I was missing some transactions from another table. Thank you again for your help though.

regards

Mina

topic Re: Problem with expression in a straight table some figures incorrect in QlikView

Problem with expression in a straight table some figures incorrect

Re: Problem with expression in a straight table some figures incorrect

Re: Problem with expression in a straight table some figures incorrect