topic Pivot Table - Missing labels in QV9 in QlikView

Pivot Table - Missing labels in QV9

Fri, 12 Feb 2010 15:39:11 GMT

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?

Pivot Table - Missing labels in QV9

disqr_rm — Fri, 12 Feb 2010 16:43:44 GMT

QlikView Server 9.00 SR3 is soon to be out - in a week or two, I guess. I know there are many corrections (or bugfixes) for pivot table especially since last version. So try with that, otherwise you should contact QlikView support and report them the problem.

I hope you are not accessign reports via IE on a 64-bit machine, as IE plugin has problems when running on 64 bit machines. Just what I read, but personally never experienced or tested.

Pivot Table - Missing labels in QV9

Wed, 17 Feb 2010 20:16:47 GMT

I have tested the latest version of QlikView 9 (SR3) and I have the same problem as you.

Pivot Table - Missing labels in QV9

rwunderlich — Wed, 17 Feb 2010 21:12:48 GMT

I see this in the SR3 Release Notes Addendum:

"PivotTables can under some circumstances get the labels of the expressions corrupted; If a pivot table contain a minimum of two expressions and is pivoted so that the array of expressions are no longer the rightmost "dimension" the strings for the labels can get corrupted."

-Rob

Pivot Table - Missing labels in QV9

jbeierschmitt — Thu, 18 Feb 2010 18:24:40 GMT

We upgraded to the IE Plugin SR3 - the "What's New in QV9.qvw" shows blank/white space on the Dashboard and Background tabs - there are no issues with the IE Plugin SR2.

Pivot Table - Missing labels in QV9

Thu, 25 Feb 2010 15:10:56 GMT

I am having the same issue. Do you know if there are any work-arounds for this?

Pivot Table - Missing labels in QV9

Thu, 25 Feb 2010 16:35:53 GMT

I had the same problem in version 9 SR3.

I downgraded to SR2 and the labels are correct.

Pivot Table - Missing labels in QV9

Thu, 25 Feb 2010 17:01:33 GMT

I have found that you can re-create some pivot tables depending on your layout using straight tables with the Horizontal option chosen on the Presentation tab. This has fixed those of mine where I had one dimension with the values going across the top and my calculated measures going down the left.

Example:

Country is the dimension at the top and my calculations are in the leftmost column.

country US Canada

# customers 1000 50

# new - 2009 500 40

Pivot Table - Missing labels in QV9

Sat, 27 Feb 2010 10:21:27 GMT

Hello, I have the same issue.

There is blog post from Qliktech saying there is a patch release which fixes this issue - but I cannot access the complete post.

Does someone know how we can get this patch?

Patch : QV SR3, build 9.00.7439

Thanks, Patrice

Pivot Table - Missing labels in QV9

Tue, 02 Mar 2010 12:13:51 GMT

Hi, same problem here, do you have a link to that post perhaps? Thanks, Lukas

Pivot Table - Missing labels in QV9

Tue, 02 Mar 2010 14:30:55 GMT

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

Pivot Table - Missing labels in QV9

Tue, 02 Mar 2010 14:36:37 GMT

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

Pivot Table - Missing labels in QV9

Tue, 02 Mar 2010 14:45:55 GMT

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

Pivot Table - Missing labels in QV9

Thu, 04 Mar 2010 11:27:36 GMT

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

Pivot Table - Missing labels in QV9

Thu, 04 Mar 2010 17:31:16 GMT

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

Pivot Table - Missing labels in QV9

Fri, 05 Mar 2010 23:53:05 GMT

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

Pivot Table - Missing labels in QV9

Sat, 06 Mar 2010 00:01:58 GMT

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.

Pivot Table - Missing labels in QV9

Sat, 06 Mar 2010 00:14:27 GMT

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.

Pivot Table - Missing labels in QV9

Sat, 06 Mar 2010 00:18:05 GMT

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

Pivot Table - Missing labels in QV9

Mon, 08 Mar 2010 15:34:26 GMT

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