Pivot Table - Missing labels in QV9

[#1]

We have recently upgraded from QV8.5 to QV9 and a very strange behaviour has appeared. In our Pivot Tables the labels seems to live a life of their own. Sometimes they show up, sometimes one label shows up and sometimes all labels are blank. Scrolling up and down sometimes help and other similar things.

It seems like this behaviour appears in the Pivot Tables where we have moved a dimension up to the columns.

Everything worked without problems in 8.5.
Anyone else who has experienced a similar behaviour or have any idea what could be wrong?

[#2]

Hi, Qliktech Support told me it was an internal blog post, that is why we cannot access it.

I also learned today there will be a new SR3 version release very soon (Wednesday 3.3.10). That should fix this issue.

Best, Patrice

[#3]

Hi - thanks for your answer. Very interesting. 🙂

Support just told me they will release SR3 9.00.7450 on Friday (March 5th) and recommended to wait for that instead of using .7439 as 7450 will fix a number of other known bugs.

Cheers, Lukas

[#4]

This is the same thing that QlikTech told me. I opted not to install the patch as it would require reinstalling the entire QVS.

[#5]

9.00.7440 has been released which should have fixed the issue.

I've installed the latest QV Desktop & the IE Plugin.

In QV Desktops the labels show correctly now, in the IE Plugin they do not.

I will re-install the server this evening to see if this perhaps helps....

Cheers, Lukas

[#6]

UPDATE: I updated the QlikView Server to 9.00.7440 as well which has solved the issue.

[#7]

I am experiencing this issue with 8.5, though it is consistently inconsistent across servers (version 8.5, no clustering of servers).

[#8]

Thank you for the idea kwymore (using straight table). The challenge is that I have no dimension for the pivot table I'm using and I have found that using a blank dimesion =' ' degrades performance. We are already loaded down w/ 250M + rows, so performance is important. (http://community.qlik.com/forums/p/26465/101385.aspx#101385)

I could, however, keep the current format and use a text object on top of the labels -- try to make it look like it is just the chart. The only problem would be if a user exported the numbers -- 'hey, no labels'. Silly QlikView. We love and hate you and couldn't do this incredible analysis without you.

[#9]

My charts didn't have actual dimensions either so I just put in a dimension of ="metrics" with the label field being blank so it just uses "metrics" as the label.

I sped up performance by using set analysis (dropped my overall CalcTimes on each chart by about 60-70%). This cured a large number of my pivot issues but on the pivot tables where I actually had dimensions returning more than one value, I still have the missing label issue. We can fix it by upgrading to the new version of SR3 but we don't have the time right now.

[#10]

You can upgrade to the new version of SR3 which I think was posted to the site on 3/5/2010. This version includes a couple of fixes that were not in the first release of SR3. Fixes below:

Bug ID	Title
25276	Performance optimizations for handling many small requests in the server (*)
25798	Error exporting document layout
25803	Open URL does not work in the plugin
25829	Cannot run QlikView Server on Domain Controller
25907	Ctrl + Select in Multibox - Ajax SR3 - Connection Lost

(*) The manifestation of this bug is that certain types of pivot boxes fail to work or even force a server disconnect.

The actual version ID is SR3 - 9.0.7440

[#11]

Good information about the new version of SR3. Thank you for sharing.