topic Re: wrong totals pivot table in App Development

wrong totals pivot table

Simon4 — Thu, 01 Dec 2022 13:12:16 GMT

hi all,

I am making a table with WIP netto sales price, but the totals in my pivot table don't add up.

how can i overcome this?

should be €14.249.879,14 but instead it is showing the total netto sales price, not the wip total netto sales price

Re: wrong totals pivot table

Or — Thu, 01 Dec 2022 13:15:04 GMT

Since you didn't include your expression or the underlying data, there's no way to tell what the problem is...

Re: wrong totals pivot table

Simon4 — Thu, 01 Dec 2022 13:17:38 GMT

the expression:

MONEY(
IF(
DATEINWIP < vpeildatum
AND
DATEOUTWIP> vpeildatum
OR
ISNULL(DATEOUTWIP)
, Sum(NETSALESAMOUNT), 0)
,'€#.##0,00', MoneyThousandSep)

the expressions sums the salesprice of all the work in progress. when i unfold the tables and total them in excel they count up to the right total: 14 million, just like in the left table. But qlik shows the total of ALL salesprices. not filtering out the wip.

Re: wrong totals pivot table

Simon4 — Thu, 01 Dec 2022 13:18:07 GMT

vpeildatum is a variable for a date that can be chosen with a datepicker

Re: wrong totals pivot table

Or — Thu, 01 Dec 2022 13:28:23 GMT

For starters, I'd suggest you try moving the if() statement inside the Sum() statement rather than vice versa. That's the most likely issue (again, without the underlying data, it's hard to tell more).