Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
martinpohl
Partner - Master
Partner - Master

QV12 SR4 Pivot table

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......

6 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

martinpohl
Partner - Master
Partner - Master
Author

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

David-Wong
Employee
Employee

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

martinpohl
Partner - Master
Partner - Master
Author

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

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

-Rob

Eric_Tay
Employee
Employee

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