topic Re: Subtotal in Pivot QV12 SR5 missing in QlikView

Subtotal in Pivot QV12 SR5 missing

stabben23 — Wed, 28 Sep 2016 12:04:24 GMT

Hi,

anyone else that have problem With subtotal in Pivot in QV12 SR5.

Just download it and find this:

Re: Subtotal in Pivot QV12 SR5 missing

sunny_talwar — Wed, 28 Sep 2016 12:05:56 GMT

What is your expression?

Re: Subtotal in Pivot QV12 SR5 missing

stabben23 — Wed, 28 Sep 2016 12:07:46 GMT

SUM(m3)

Re: Subtotal in Pivot QV12 SR5 missing

sunny_talwar — Wed, 28 Sep 2016 12:12:50 GMT

I have QV12 SR5, but have not tested this, would you be able to share your app for testing or else I will have to create one to test

Re: Subtotal in Pivot QV12 SR5 missing

stabben23 — Wed, 28 Sep 2016 12:18:29 GMT

Sorry to share, but to create a Pivottable in a Application will not be a big problem for You my friend I'll wait.

Re: Subtotal in Pivot QV12 SR5 missing

stabben23 — Wed, 28 Sep 2016 12:22:09 GMT

just use "Insert--> test script" and you are fast on track.

Re: Subtotal in Pivot QV12 SR5 missing

sunny_talwar — Wed, 28 Sep 2016 12:23:41 GMT

Seems to be working

What do you see when you open this?

Re: Subtotal in Pivot QV12 SR5 missing

stabben23 — Wed, 28 Sep 2016 12:31:36 GMT

Ok, some more strange Things, I have Upgrade from SR1 to SR5 today. The first pic is a New Application created in SR5. Second pic is a Application opened in SR5 but created in SR1. The Dimension Limit is in the SR1 created Application, not in the SR5 created Application.

Re: Subtotal in Pivot QV12 SR5 missing

Wed, 28 Sep 2016 12:33:19 GMT

Download means exporting to excel file aa

Re: Subtotal in Pivot QV12 SR5 missing

sunny_talwar — Wed, 28 Sep 2016 12:34:03 GMT

Yes, that indeed is strange.

Re: Subtotal in Pivot QV12 SR5 missing

stabben23 — Wed, 28 Sep 2016 12:34:28 GMT

Look at latest comment from me. Works if a create a New documents.

Re: Subtotal in Pivot QV12 SR5 missing

stabben23 — Wed, 28 Sep 2016 12:45:53 GMT

That SR is not compatible is very bad.

Re: Subtotal in Pivot QV12 SR5 missing

kkkumar82 — Wed, 28 Sep 2016 12:50:41 GMT

I was also able to "Dimension limits" for a pivot table in QV 12 SR1, if thought it is an upgrade which i missed but to my craze after that I tried once again I didn't get it.

Is there really any update on dimension limits for pivot table guys, if so from which version.

Re: Subtotal in Pivot QV12 SR5 missing

stabben23 — Wed, 28 Sep 2016 12:56:00 GMT

Hi Kiran,

if a create a New document in QV12 SR5 (last) you will not find it. When a open up a document in SR5 created in SR1 I'll see the Dimension limits. So if this is an Eastern or a bug, i dont know

Re: Subtotal in Pivot QV12 SR5 missing

stabben23 — Wed, 28 Sep 2016 13:00:37 GMT

I can live without Dimension limit but not without subtotals in Pivot tables.

Re: Subtotal in Pivot QV12 SR5 missing

stabben23 — Wed, 28 Sep 2016 13:13:52 GMT

I have opened up some more Application build in different Version, QV11 SR12, QV12 SR1 and it looks like Subtotals is there. But still no success With the one a work With right now and there is also the Dimension limit tab. I cant find this tab no where else.

Re: Subtotal in Pivot QV12 SR5 missing

kji — Wed, 28 Sep 2016 13:42:20 GMT

You can try running the following macro to see if it fixes your problem.

sub test

prop=ActiveDocument.GetProperties

prop.CompatibelPivotCalcMode=true

ActiveDocument.Setproperties(prop)

end sub

CompatibelPivotCalcMode should always be true for QlikView, not sure how it could have changed except trough a macro.

Re: Subtotal in Pivot QV12 SR5 missing

martinpedersen — Wed, 12 Jul 2017 07:51:50 GMT

It looks like some sort of bug when editing the document properties that sets the CompatibelPivotCalcMode as False. This macro handles this issue - so thank you