topic Re: partial sums not displaying in QlikView

partial sums not displaying

qlikhans — Wed, 31 Jan 2018 07:54:54 GMT

Dear all

can anyone explain why the partial sums do not work in attached example?

thanks for the help

Hans

kaushiknsolanki — Wed, 31 Jan 2018 07:57:26 GMT

Hi,

It is already their.

Can you help us what you are looking at?

I can see the totals for both dimensions in all charts.

Regards,

Kaushik Solanki

qlikhans — Wed, 31 Jan 2018 08:36:25 GMT

Hi Kaushik

below a screebshot of what I see

the partial totals are set to Top

I expect to see totals as shown below

prma7799 — Wed, 31 Jan 2018 08:42:17 GMT

Like this??

qlikhans — Wed, 31 Jan 2018 08:48:20 GMT

Hi P M

no picture?

kaushiknsolanki — Wed, 31 Jan 2018 08:51:16 GMT

Hi,

It wont come because Actual Amount and Budget amount is not the dimension.

Partial sum works on dimension values.

If you want total for both expression, you will have to create a new expression which will be Sum(Actual) + Sum(Budget)

Regards,

Kaushik Solanki

prma7799 — Wed, 31 Jan 2018 09:10:50 GMT

Please check in the attached qvw...

qlikhans — Wed, 31 Jan 2018 09:15:06 GMT

Gentlemen

some magic happened.

I did the 100th refresh and the partial totals appeared.

Thank you for the help