topic Re: Pivot Table - Incorrect Partial Sums in QlikView

Pivot Table - Incorrect Partial Sums

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

Hi There

I'm using a three dimensional pivot table shown below-

Here's the expression i'm using to calculate Cost of actual readings (OMR) -

Column(2)*(

If(

network_node_type='City',

Sum(

{<[MRBC Cost]={'Number of actual readings'}>} [Unit_Cost (City)]

)

(Sum(

{<[MRBC Cost]={'Number of actual readings'}>} [Unit_Cost (Rural)]

)

)))

*network node type is the 3rd dimension and column(2) is not in the snip above(It's towards left)

The partial sums are incorrect. please help.

sunny_talwar — Fri, 09 Sep 2016 22:56:47 GMT

You can try like this:

Sum(Aggr(<Replace Column(2) with the actual expression here> *

If(network_node_type='City',

Sum({<[MRBC Cost]={'Number of actual readings'}>} [Unit_Cost (City)]),

Sum({<[MRBC Cost]={'Number of actual readings'}>} [Unit_Cost (Rural)])), Year, Month, [Connection Type]))

ashish_2511 — Sat, 10 Sep 2016 07:04:15 GMT

Wow! Thanks a ton Sunny.. That worked...

Regards

-Sneh