topic Re: Missing Total in QlikView

Missing Total

tmumaw — Mon, 24 Sep 2018 17:33:46 GMT

Hi all,

I have a pivot table and I can't seem to get a total for one column. Was wondering if anyone could help. Here is my calculation:

if(Sum({<Cleared = {N}>} [Amount in LC_DMBTR]) = 0,
Sum({<[Special G/L ind_UMSKZ] = {I},[Document type_BLART] -={'DA'}>}[Amount in LC_DMBTR]) * 1 ) +
Sum({<[Debit/Credit_Flag_SHKZG] = {D}, [Document type_BLART] = {RV}>}[Amount in LC_DMBTR])

And yes I do have the totals button selected.\

Thanks

Re: Missing Total

m_woolf — Mon, 24 Sep 2018 17:58:58 GMT

Just a guess. When you use + to add, if either expression is null the total will be null.

Maybe use rangesum instead?

Rangesum(Sum({<[Special G/L ind_UMSKZ] = {I},[Document type_BLART] -={'DA'}>}[Amount in LC_DMBTR]) * 1 ),
Sum({<[Debit/Credit_Flag_SHKZG] = {D}, [Document type_BLART] = {RV}>}[Amount in LC_DMBTR]))

Also, are you missing a closing parenthesis for your IF statement?

Re: Missing Total

tmumaw — Mon, 24 Sep 2018 18:26:00 GMT

I used the rangesum on the last column. All I got was the values in Payments Cleared. I want to sum the overpayments column.

Re: Missing Total

m_woolf — Mon, 24 Sep 2018 19:26:10 GMT

Can you share the qvw?