topic No/Incorrect totals in Pivot table in QlikView

No/Incorrect totals in Pivot table

Anonymous — Fri, 16 Nov 2018 14:00:30 GMT

I have a Pivot table (see screenshot), but the totals are incorrect.

The numbers in the tabel calculated with the extression:

if([Start op]<[PERe.autoCalendar.Date],if([Geannuleerd per]>'0',if([Einde contract op]<[PERe.autoCalendar.Date],0,1),1),'0')

-[PERe] is from a tabel with the end-dates of every month

- [Geannuleerd per], [Einde contract op] and [Start op] are all date-fields

This results in a 1 (one) of 0 (nul) in the tabel.

I can only turn [Show totals] on or off. And they are turn on for [Memberschip] and [Lidmaatschap ID].

Even with only one dimention (Membership or Lidmaatschap ID) I don't get any totals.

Re: No/Incorrect totals in Pivot table

Marco — Fri, 16 Nov 2018 14:16:39 GMT

Hi,
add "Sum" in expression:
Sum(if([Start op]<[PERe.autoCalendar.Date],if([Geannuleerd per]>0,if([Einde contract op]<[PERe.autoCalendar.Date],0,1),1),0))

Re: No/Incorrect totals in Pivot table

Anonymous — Fri, 16 Nov 2018 14:35:30 GMT

Tnx, that did the trick.

Expressions are still a bit of a challenge for me. Every . and , counts. I'm realy familiar with Excel, but learn every day on Expressions. Realy need to get started with that training for Expressions.

Tnx again.