topic Re: QV12 SR4 Pivot table in QlikView

QV12 SR4 Pivot table

martinpohl — Wed, 06 Jul 2016 18:27:10 GMT

In QlikView 12 SR4 Theres is a new tab in the chart type Pivot chart: limitations (this tab was being available in other chart types but not in a Pivot chart)

but:

Now the setting subtotal on tab presentation hast no effect anymore!

Subtotals on the dedicated dimensions are only available if the option total on tab limitations is set.

Has anyone else the same effect ?

By the way: I can't find this New "feature" in the release notes......

Re: QV12 SR4 Pivot table

rwunderlich — Wed, 06 Jul 2016 19:03:57 GMT

I'm not seeing a Dimension Limitations tab in QV12 SR4 Pivot table. I do see it for Straight Table. Can you double check you have Pivot Table set as the type, and if so, post a sample?

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: QV12 SR4 Pivot table

martinpohl — Thu, 07 Jul 2016 10:40:51 GMT

I'm a liitle bit confused.

you are right... maybe.

Yesterday, there was this option available, today it isn't.

Maybe the tab was a result of changing the chart type from straight table to pivot table but I can't replicate this today.

Sorry

Re: QV12 SR4 Pivot table

David-Wong — Wed, 20 Jul 2016 03:53:30 GMT

Martin,

You are not alone. I have been conducting some training recently and Dimension Limit tab did pop up in Pivot table a few times during my training, twice in my qvw files and twice in my students qvw files.

Initially I thought it was a bug in QV11.2 release but then yesterday, someone in the class who has QV12 installed had the same issues.

The strange thing is the next day, when I open up my file, such Dimension Limit is no longer appearing in my Pivot table. Since I have noticed this happened before, therefore, yesterday, when a student of mine having the same issue, I have checked that he is on Version 12, and he did select Pivot table as his chart type.

I have tried to replicate the issue but with NO LUCK.

Nonetheless, I do feel that this issue might be triggered if we were working a lots in the qvw document without saving the file, but I could be wrong as I am not able to replicate it so far.

As I'm not able to replicate the issue nor can preserve the issue and to report an error, this really not gonna help in locking the issue and submit it for fixing.

I will share again in this space if I have came across this issue or able to replicate the issue. But if anyone has this issue and know how to trigger such issue, kindly share.

Thank you,

David

Re: QV12 SR4 Pivot table

martinpohl — Wed, 20 Jul 2016 08:30:11 GMT

Hello David,

thank you for your reply.

I had the same behaviour and also I can't replicate the effect. But I'm happy that this happens to someone else.

Regards

Re: QV12 SR4 Pivot table

rwunderlich — Wed, 20 Jul 2016 20:45:02 GMT

At least we all know now that Martin has not lost his mind

-Rob

Re: QV12 SR4 Pivot table

Eric_Tay — Thu, 01 Sep 2016 03:34:45 GMT

Hello David and Martin,

Glad to see that I am not the only one who experienced this.

Hopefully R&D team will provide dimension limit tab for Pivot Table in the next release.

Eric