topic Re: Wrong % total in pivot table in QlikView

Wrong % total in pivot table

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

Hi,

Am getting wrong grand total in pivot table.Previously it is good .

Thanks..

Re: Wrong % total in pivot table

sunny_talwar — Sun, 27 Mar 2016 14:29:32 GMT

Can you provide more details? What is the expression you are using? What changed that the totals changed from what was expected? What is the expected output?

Re: Wrong % total in pivot table

nareshthavidishetty — Sun, 27 Mar 2016 14:39:15 GMT

Hi,

Dimension : =if(KEY3='Appliances' or KEY3='Electronics' or KEY3='Furniture' or KEY3='Mattress' or KEY3='Office',KEY3)

Expression:1

(Sum({<DATE={'$(Vyesterday)'},Indicator={1}>}Dollars)

Sum ({<DATE={'$(vDayLY)'},Indicator={1}>} Dollars))

Sum ({<DATE={'$(vDayLY)'},Indicator={1}>} Dollars)

Expression:2

(Sum ({<DATE= {">=$(vMonthStart)<=$(Vyesterday)"},Indicator={1}>} Dollars)-Sum ({<DATE= {">=$(vMonthStartLY)<=$(vPrevYesterday)"},Indicator={1}>} Dollars))

Sum ({<DATE= {">=$(vMonthStartLY)<=$(vPrevYesterday)"},Indicator={1}>} Dollars)

Desired O/P:

2.00%

-11.35%

15.48%

3.17%

-17.21%

Total =-7.91%

But it gives -0.012%.

Note: Didn't change any chart properties it working good since log time.

Thanks..

Re: Wrong % total in pivot table

sunny_talwar — Sun, 27 Mar 2016 15:00:45 GMT

Can you try this:

Sum(Aggr((Sum ({<DATE= {">=$(vMonthStart)<=$(Vyesterday)"},Indicator={1}>} Dollars)-Sum ({<DATE= {">=$(vMonthStartLY)<=$(vPrevYesterday)"},Indicator={1}>} Dollars))

Sum ({<DATE= {">=$(vMonthStartLY)<=$(vPrevYesterday)"},Indicator={1}>} Dollars), KEY3))

Re: Wrong % total in pivot table

swuehl — Sun, 27 Mar 2016 15:12:42 GMT

Could you explain how you got to -7.91% ? Or why do you call -0.012% wrong and -7.91% correct?

It seems to me that you are calculating something like a growth rate per dimension value.

IMHO, I would expect to see in the total line the growth rate calculated from the total aggregates, and not summing up or averaging the growth rate of the dimension lines.

Hence, -0.012% might be correct, at least I don't see an issue with using the expression total here instead of an aggregation-of-rows.

Regards,

Stefan