topic Re: Problem with qlikview access point: table not show when scroll in QlikView

Problem with qlikview access point: table not show when scroll

danosoft — Tue, 18 Jul 2023 14:39:34 GMT

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

Re: Problem with qlikview access point: table not show when scroll

marcus_sommer — Wed, 19 Jul 2023 06:06:56 GMT

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.

Re: Problem with qlikview access point: table not show when scroll

danosoft — Wed, 19 Jul 2023 09:03:36 GMT

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

Re: Problem with qlikview access point: table not show when scroll

marcus_sommer — Wed, 19 Jul 2023 10:54:10 GMT

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.

Re: Problem with qlikview access point: table not show when scroll

danosoft — Wed, 19 Jul 2023 11:34:09 GMT

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

Re: Problem with qlikview access point: table not show when scroll

marcus_sommer — Wed, 19 Jul 2023 11:54:31 GMT

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

Re: Problem with qlikview access point: table not show when scroll

danosoft — Wed, 19 Jul 2023 12:02:40 GMT

how can i do this?

Re: Problem with qlikview access point: table not show when scroll

marcus_sommer — Wed, 19 Jul 2023 12:43:43 GMT

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

Re: Problem with qlikview access point: table not show when scroll

danosoft — Wed, 19 Jul 2023 13:23:12 GMT

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

Re: Problem with qlikview access point: table not show when scroll

marcus_sommer — Wed, 19 Jul 2023 13:27:30 GMT

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.

Re: Problem with qlikview access point: table not show when scroll

danosoft — Wed, 19 Jul 2023 13:31:06 GMT

and how do you put filters on them from within the dimension values?

Re: Problem with qlikview access point: table not show when scroll

marcus_sommer — Wed, 19 Jul 2023 14:02:32 GMT

Of course the inner-object dimension-values must be visible to be accessible. More comfortable will be just to use a list-box.