Subtotal in Pivot QV12 SR5 missing

[stabben23]

Hi,

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

Just download it and find this:

[stabben23]

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

[stabben23]

That SR is not compatible is very bad.

[kkkumar82]

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.

[stabben23]

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

[stabben23]

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

[stabben23]

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.

[kji]

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.

[martinpedersen]

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