topic Re: Problem with pivot table total in QlikView

Problem with pivot table total

riho92qv — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

i have a problem with pivot table column total value

Problem is actual for me only in last column. I undestand that value 48 411,36 = 2,80 * 17320, but i need there sum of values in last column, and this sum is 33 898,13.

Can anyone help me. I will attach fragment of my Qlikview file.Thank you for any help.

Riho

Re: Problem with pivot table total

Anil_Babu_Samineni — Sun, 11 Feb 2018 12:39:42 GMT

PFA

=Sum(Aggr(if(Sum({$ <Year = {"$(=min(Year))"}>}ExtCost)=0 Or Sum({$ <Year = {"$(=max(Year))"}>}ExtCost)=0,

0, (Sum({$ <Year = {"$(=min(Year))"}>}ExtCost) / Sum({$ <Year = {"$(=min(Year))"}>}OurQty)

-Sum({$ <Year = {"$(=max(Year))"}>}ExtCost) / Sum({$ <Year = {"$(=max(Year))"}>}OurQty)) * Sum({$ <Year = {"$(=max(Year))"}>}OurQty) )

,PartGroup, PartNum))

Re: Problem with pivot table total

riho92qv — Sun, 11 Feb 2018 13:25:53 GMT

Thanks Anil, it works fine. I also tried to use Aggr function, but I forgot add dimenions and get 0 values.

Riho

Re: Problem with pivot table total

Anil_Babu_Samineni — Sun, 11 Feb 2018 13:29:36 GMT

Great, Not sure why you draw in Pivot table? Even, If you change it to Straight table using (Sum option) will deserve.

Please close this thread by flag correct answer and helpful for other response?