Horizantal scroll bar on Chart Straight table

[#1]

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?

[IAMDV]

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,

DV

www.QlikShare.com

[#3]

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.

[AbhijitBansode]

Hi Deepak,

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

Is any step missing?

[stevelord]

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.

[#6 · Accepted solution]

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.

[stevelord]

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.

[#8]

Thanks Steve

[dgreenberg]

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?

[Anonymous]

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

[dgreenberg]

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.