topic Re: Horizantal scroll bar on Chart Straight table in QlikView

Horizantal scroll bar on Chart Straight table

Fri, 21 Sep 2012 14:27:38 GMT

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?

Re: Horizantal scroll bar on Chart Straight table

Anonymous — Sun, 23 Sep 2012 21:58:04 GMT

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

Re: Horizantal scroll bar on Chart Straight table

Mon, 24 Sep 2012 14:59:00 GMT

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.

Re: Horizantal scroll bar on Chart Straight table

Anonymous — Mon, 24 Sep 2012 15:28:08 GMT

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

Re: Horizantal scroll bar on Chart Straight table

whiteline — Mon, 24 Sep 2012 15:38:01 GMT

Hi, Michael.

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

Re: Horizantal scroll bar on Chart Straight table

Anonymous — Mon, 24 Sep 2012 15:42:00 GMT

Thank whiteline,

Frozen rows makes sense too, agree.

Re: Horizantal scroll bar on Chart Straight table

rajni_batra — Tue, 25 Sep 2012 06:40:17 GMT

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

Re: Horizantal scroll bar on Chart Straight table

whiteline — Tue, 25 Sep 2012 06:47:58 GMT

😃

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

We talked about ideas and improvements.

Re: Horizantal scroll bar on Chart Straight table

rajni_batra — Tue, 25 Sep 2012 06:57:41 GMT

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

Re: Horizantal scroll bar on Chart Straight table

whiteline — Tue, 25 Sep 2012 07:24:28 GMT

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.

Re: Horizantal scroll bar on Chart Straight table

IAMDV — Mon, 29 Oct 2012 12:45:52 GMT

Dear All,

I understand that it's old thread but you can get the scroll bar on the straight table for the Dimensions. Although, you can go down the route of having one dimension (unique & most granular dimension field) and then you can have rest of them as expression either with aggregation or just using the ONLY() function. As Michael suggested, you can hide the Dimension column. This works but think about the CPU overhead of calculating the expression everytime a selection is made or even if you move the object position (Inspite of havign caching). This can become slow & resource intense.

My solution: Create chart (striaght table) as you would normally do then add the expression. Once you are done then hold the header row of any expression and then a blue vertical line appears (which means you can swap the column position). Now you need to move this expression to extreme left hand side before or near your dimensions. This way you are tricking QlikView to show the horizantal scroll bar from extreme left hand side which includes your dimension.

I hope this helps!

Cheers,

www.QlikShare.com

Re: Horizantal scroll bar on Chart Straight table

Mon, 08 Jul 2013 13:27:56 GMT

Hello Deepak,

I have a requirement, user should have option to select dimensions on straight table. So i have a list box when user selects it will show (or appear) in a straight table. But i am having trouble controlling the chart size and with the scroll bar. i am not able to fix the chart size. chart size increasing with dimension selection from the listbox. any idea how to control this.

i really dont want to use these dimensions as expressions.

Re: Horizantal scroll bar on Chart Straight table

AbhijitBansode — Mon, 25 Nov 2013 13:02:19 GMT

Hi Deepak,

I have done similar to what you have told but not getting horizantal scroll bar.

Is any step missing?

Re: Horizantal scroll bar on Chart Straight table

stevelord — Tue, 23 Sep 2014 18:12:46 GMT

I can confirm Michael's solution is good. It also adds the handy capability of putting in a totals row if you want, to say, count the number of people or events in your list.

To make those expressions columns appear and disappear based on listbox/dimension selection, you could also check the conditional box and maybe write a little expression like count(fieldname>0) or something- do a little trial and error on that. (The expressions columns themselves might just be '=fieldname'.)

Someone should really give mike some correct answer credit here. I was linked to this post from another post where I asked a similar question.

Re: Horizantal scroll bar on Chart Straight table

Fri, 09 Jan 2015 11:57:52 GMT

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.

Re: Horizantal scroll bar on Chart Straight table

stevelord — Fri, 09 Jan 2015 16:48:26 GMT

Thanks! I have some containers and this fact about the scroll bar behavior didn't register. I just scrolled around one of the charts in a container and see it behaving as you say and as I wanted. Good catch, efficient solution, sorry I can't hand off more correct answer credits in this string. Thanks again!

PS> I wander around old posts all the time, though I try to pick the most current old post on a particular issue. Google kind of made things immortal these days.

Re: Horizantal scroll bar on Chart Straight table

Fri, 09 Jan 2015 17:37:35 GMT

Thanks Steve

Re: Horizantal scroll bar on Chart Straight table

dgreenberg — Mon, 08 Jun 2015 19:52:28 GMT

Does anyone have a rhyme or reason as to why sometimes dragging the expression to the left works and creates a horizontal scrollbar and sometimes it does not?

Re: Horizantal scroll bar on Chart Straight table

Anonymous — Tue, 09 Jun 2015 00:54:53 GMT

You have to move at least one expression to the left of the at least one dimension to get the scroll bar.

Re: Horizantal scroll bar on Chart Straight table

dgreenberg — Tue, 09 Jun 2015 11:37:13 GMT

Thank you but not the answer I was looking for.

That's the obvious answer and one would think it would consistantly work but it does not consistantly work for me.

I am using QV 11.20 SR 10 and I have new and existing straight table charts with 1 or more expressions to the left and mulitple dimensions. Auto size to data is not checked yet the table seems to grow and grow instead of giving a scroll bar.

I have examples I created where it works as you described but important ones where it will not function that way.