topic Re: above rows total problem in pivot table in QlikView

above rows total problem in pivot table

Wed, 28 Dec 2016 11:21:22 GMT

hi,

Re: above rows total problem in pivot table

sunny_talwar — Wed, 28 Dec 2016 12:36:16 GMT

Would you be able to share a sample to look at this issue?

Re: above rows total problem in pivot table

sunny_talwar — Thu, 29 Dec 2016 09:55:28 GMT

Not sure, but seems like some sort of bug to me where when the 'Suppress Zero Value' is checked, the expression is double counting within RangeSum

Re: above rows total problem in pivot table

Thu, 29 Dec 2016 10:12:29 GMT

hi,

1. can't replace column(1) and column(2) with actual expression because it's a big formula and if replace also it will give calculate in different way.

2. the problem which you identified is same which i found range sum is calculating wrongly when suppress zero values selected. so am looking is there any different way available to add /sum up the resulted above rows instead of putting column(3) or rangesum or above or expression.

Thanks

Re: above rows total problem in pivot table

sunny_talwar — Thu, 29 Dec 2016 10:24:52 GMT

There is another way, but that would still require you to use actual expressions instead of Column labels. One idea/suggestion would be to store your expressions within variables and then call them in your expression