Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Web-View doesn't properly support more than 37 expr. columns in pivot table?

Similar to another post I saw (referenced below) I'm having issues with wide pivot tables in web-view.

Unexpected exception occurred on Ajax Pivot Table

The pivot has 3 vertical dimensions (year, quarter, month) and one horizontal dimension (Contract Year).

Grid style.png

In the image shown above I've got two expressions.  To ensure that this isn't data-related I've not done any exciting calculations and the expressions are just "=1", "=2".

When I switch to Web View and right-click on a cell I get pop-up menu.

popupok.png

However, when I scroll across far enough and do this I get a message-box stating that an unexpected error occurred.

errmsg.png

In addition to not being able to right-click on the cell to get the pop-up menu, it's also lost the functionality whereby clicking the cell applies filtering to the dimensions.

The interesting bit of this is that the error appears only after the 37th column in the pivot table.  I've tried it with two, three, four, and five expressions and it's consistent about this.  Each time, the failure to respond normally to clicks begins on the 38th expression column.

It's as if there is some limit on the number of expression columns that are properly supported on a pivot in the Web View.  Does anyone know if this is the case and if this value can be modified?

I've attached an example QVW if anyone fancies having a play.  You'll need to do a re-load - the script contains structures to generate the test date.  It currently shows four expression columns.  It works just fine in the Personal Edition normal view, but switch to web-view and then scroll over to 2010 and right-click on something in the '1' column (37th in the grid)- you'll see the menu.  Try the '2' column (38th in the grid) and you'll get the error message.  Similarly, clicking on the cell in column 37 will apply dimension filters and clicking on column 38 won't.

Any help would be much appreciated as my clients are going just a teeny bit nuts.

Thanks.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Web-View doesn't properly support more than 37 expr. columns in pivot table?

You need to choose the plugin by opening the application. If you clicked on "view details" by the application within the access point you should have now to options for opening. One is the AJAX client and one the IE plugin. If you don't see it there you need to enable the access with the plugin within the qmc by documents --> server --> availability.

- Marcus

11 Replies
Not applicable

Re: Web-View doesn't properly support more than 37 expr. columns in pivot table?

OK - I did another experiment.  This time a pivot with only 1 vertical dimension and 40 expressions, 1, 2, 3... 40.

Clicking works for the 39th expression and not the 40th.

I added an extra dimension and here's interesting.  With the first dimension collapsed, the 39th still worked.  When I expanded the first dimension the 39th column no longer responds to mouse clicks, but the 38th does.

It seems as though only the first 40 columns in a pivot will respond to clicks in Web-View.

gautik92
Valued Contributor III

Re: Web-View doesn't properly support more than 37 expr. columns in pivot table?

try creating dynamic reports

that is  dynamically you can select dimensions and also measures

Not applicable

Re: Web-View doesn't properly support more than 37 expr. columns in pivot table?

Alas, that's not what the client wants. 

MVP & Luminary
MVP & Luminary

Re: Web-View doesn't properly support more than 37 expr. columns in pivot table?

You mean webview in desktop-client or per browser within the access point? AFAIK webview is rendering with the IE and other browsers might not have this feature. Another thought should be go to the release which you used then this might be fixed in a newer release.

- Marcus

Not applicable

Re: Web-View doesn't properly support more than 37 expr. columns in pivot table?

Hi Marcus,

I'm experiencing this with the Personal Edition rendering in Web View.  PE Version 11.20.12577.0 SR8

--AND ALSO--

From the server when the document is uploaded and viewed in IE. ...  Build Number            11.20.12904.0409.10

...so, in answer to your question, it's both; local and browser via the access point.

I'm not in a position to request that the client installs something other than IE.

The clicks work perfectly for the entire width of the pivot when using PE in non-web-view.

Thanks,

   Mark

MVP & Luminary
MVP & Luminary

Re: Web-View doesn't properly support more than 37 expr. columns in pivot table?

If you need the IE you could use the IE plugin with them those error probably not will occur. Otherwise I suggest to consider the use of another browsers then the IE is not really up to date and on the same level like the others.

- Marcus

Not applicable

Re: Web-View doesn't properly support more than 37 expr. columns in pivot table?

Hi Marcus.

I installed the plug-in and the problem persists.  However, there's nothing spectacularly different on-screen so is there a way of telling whether or not the plug-in was in use?

Thanks.

MVP & Luminary
MVP & Luminary

Re: Web-View doesn't properly support more than 37 expr. columns in pivot table?

You need to choose the plugin by opening the application. If you clicked on "view details" by the application within the access point you should have now to options for opening. One is the AJAX client and one the IE plugin. If you don't see it there you need to enable the access with the plugin within the qmc by documents --> server --> availability.

- Marcus

Not applicable

Re: Web-View doesn't properly support more than 37 expr. columns in pivot table?

Spot on Marcus!!!

Sincere thanks.

  Mark