topic Re: Re: Total problem in Pivot table in QlikView

Total problem in Pivot table

piekepotloed — Mon, 28 Jul 2014 09:34:32 GMT

Hi,

I've an expression that looks like this:

sum({$<Grootboek_type_revenue={2}, Maand*={"*"}>}Dgbk_bedrag)*if(Left(ArcusRapportageNiveau,2)='29' or Left(ArcusRapportageNiveau,2)='43' ,1,-1))+(sum({$<Grootboek_type_revenue={3}, Maand*={"*"}>}Dgbk_bedrag))

If I check the "Show Partial Sums"checkbox at the dimension tab, the total shown is not the same as the total of the expressions. How can I get this wrigth?

Kind regards,

Peter

Re: Total problem in Pivot table

MK_QSL — Mon, 28 Jul 2014 09:44:14 GMT

Use Dimensionality() or SecondaryDimensionality()...

Provide your sample file to work..

Re: Total problem in Pivot table

piekepotloed — Tue, 29 Jul 2014 06:34:03 GMT

Hi Manisch,

Thanks for your support, but I'm not getting there...I provide a sample file as you've asked for.

Peter

Re: Re: Total problem in Pivot table

tresB — Tue, 29 Jul 2014 06:43:24 GMT

Like this?

=Sum(Aggr((sum({$<Grootboek_type_revenue={2}, Maand*={"*"}>}Dgbk_bedrag)*if(Left(ArcusRapportageNiveau,2)='29' or Left(ArcusRapportageNiveau,2)='43' ,1,-1))+(sum({$<Grootboek_type_revenue={3}, Maand*={"*"}>}Dgbk_bedrag)),ArcusTelNiveau,ArcusRapportageNiveau))