Solved: Re: Horizantal scroll bar on Chart Straight table - Qlik Community

Report Inappropriate Content · ‎2012-09-21

Currently we have a Chart Box with 20 columns expected to grow to 40-60 columns. The chart box allows us to specify the x and y position along with height and width. When the displayable values exceed those limits scroll bars appear on the horizontal and vertical.

Now we are trying to do the same with a Chart Straight Table as we need to be able to support the <url> capability. We have set the same x, y, width and height parameters. The options are also the same on the layout tab for both. However the Straight table does not create the horizontal scroll bar.

Is there an option somewhere we are missing?

Report Inappropriate Content · ‎2015-01-09

Hi - I know this is an old thread, but I've managed to solve something like this by using a container object - so placing the chart into the container - and then you can resize the container as you wish.

View solution in original post

Anonymous · ‎2012-09-23

This is how I resloved this in a few cases when the clients really wanted tables with an unreasonable number of columns (up to 200 and more):
Only one dimension field. It must be the field that defines the row. Say, if the table row is information about a person, the dimesnsion is this person's unique ID. Not the name, because names are not unique. In situations when there is no a single field that defines the row, it can be a calculated dimension based on multiple fields.
Next, all other columns are expressions, not dimensions.
And the last, hide the dimension, so all you see is the expressions. It gives you horizontal scroll bar, and as many columns as needed.

Regards,
Michael

Report Inappropriate Content · ‎2012-09-24

Interestingly enough, the desktop client we could not get the horizontal scroll bar to appear. But once we place the document on the extranet and the users opened document with the AJAX client the horizontal scroll bar appeared.

So, we were able to use as is without trying your method.

Note: there is a bug in the desktop client apparently that does not show the horizontal scroll bar.

Anonymous · ‎2012-09-24

Good you don't need this, it is time-consuming. My "many-column" client were using desktop client...

As for the classifying "no scrollbar for dimensions" as a bug - I'm sure it is intentional because it does make sense in most cases. Anyway, try to talk to QlikTech about this. It would be convenient to have scrollbar when and how you want it, and be able to freeze some first columns, no matter dimensions or expressions.

Regards,
Michael

whiteline · ‎2012-09-24

Hi, Michael.

+1

In addition as an idea: not only freeze first columns but also the total row at the top of a straight table.

Anonymous · ‎2012-09-24

Thank whiteline,

Frozen rows makes sense too, agree.

rajni_batra · ‎2012-09-25

Hi Whiteline,

i am alos having the same problem can u please tell me how do i freeze the colomn i also have more then 20 dmension in my table

whiteline · ‎2012-09-25

😃

You can't. You can create a separate object.

We talked about ideas and improvements.

rajni_batra · ‎2012-09-25

So u mean there is no option to sown horizntal scroll for dimensions this is so irritating. then how do i manage my client??

whiteline · ‎2012-09-25

Yes, that's what I mean.

As Michael suggested you could try to achive the similar looking table using expressions. Then you will have horizontal scroll bar.

As for client, you could try to understand why he wants a huge table and suggest another elegant solution according to his needs, of course if it's possible.