Problem with qlikview access point: table not show when scroll

[danosoft]

As you can see in the picture my table displayed by access point if I scroll it down with the scrollbars it is not seen..... it is a normal table object. I use Firefox and Chrome

[marcus_sommer]

I would play a bit with the object, for example reducing the number of rows with appropriate selections and/or exporting the table to Excel and/or disabling some columns ... I assume some valuable hints will occur.

[danosoft]

Unfortunately I need all the data in the table and the columns, there are 2 millions rows .... for that it not work?

[marcus_sommer]

It are just too much rows & columns - probably not for the Qlik calculation engine or the Qlik object-resources but very likely for the web-rendering and/or the browser engine. A website isn't designed to plot millions of rows & columns.

You may try this job with the desktop client whereby better would be to transfer this tasks into the script and to store these data as csv.

[danosoft]

is there a way to view it on the web then? because he displays them to me when I open, but if I scroll down it puts everything blank

[marcus_sommer]

Rather not - Qlik renders not the entire object else just the visible part + n rows and only if the user scrolled to a not included part the next bunch of rows will be rendered.

If it's just an occasionally task you may do it in maybe 10 - 20 slices which is surely not a nice job but possible ...  

[danosoft]

how can i do this?

[marcus_sommer]

Just selecting the data-set with period-fields and/or any other suitable fields and then exporting and then the next sub-set.

[danosoft]

ok but in the table how do I export the next sub-set when I go down with the cursor? Or do you mean making selections from combobox etc...?

[marcus_sommer]

Meant were normal selections either from the outside per list-box or maybe from the inside per dropdown in the header or on the dimension-values.