Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Highlighted
Valued Contributor

Missing Total

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

Tags (1)
3 Replies
Highlighted
Honored Contributor II

Re: Missing Total

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?

Highlighted
Valued Contributor

Re: Missing Total

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

Highlighted
Honored Contributor II

Re: Missing Total

Can you share the qvw?