topic Re: Removing Scrollbar in QlikView

Removing Scrollbar

Tue, 03 Sep 2013 07:30:18 GMT

Hi all,

I have the situation in which I have horizontal scrollbar in the screen(not the one of the chart) which I am interested to remove.

How can I do it?

Print screen is attached and the relevant scrollbar is marked in black.

Thanks,

Inna

Re: Removing Scrollbar

dmohanty — Tue, 03 Sep 2013 07:34:54 GMT

Simply, Drag all your Objects to extreme left as far as possible, just to make sure all the Sheet Objects fit into a single screen. Its a best practice to keep the List Boxes at extreeme left and charts beneath it

In the image I can see your Chart and List Box has some space in between. Try to minimize the space as far as possible. Then only your scroll bar won't appear.

Regards!!!

Re: Removing Scrollbar

miikkaqlick — Tue, 03 Sep 2013 07:42:08 GMT

If all your objects don't fit to page then you'll get scrollbar. Try to fit everything to screen.

Re: Re: Removing Scrollbar

Tue, 03 Sep 2013 08:01:14 GMT

Hi ,

I moved everything to the left (see attached), but it does not really help because I don't succeed to shrink the chart.

I also attach the model here.

Can you help me?

Thanks,

Inna,

Re: Removing Scrollbar

Tue, 03 Sep 2013 12:45:44 GMT

You need a bigger screen

or shrink the object some more.

Try to also reduce the font size...

Re: Removing Scrollbar

Tue, 03 Sep 2013 12:51:12 GMT

Hi Zama,

my problem is that I don't succeed to shrink the chart.

Do you know how to do it?

Re: Removing Scrollbar

Or — Tue, 03 Sep 2013 12:51:30 GMT

It's somewhat of an ugly workaround, but:

1) Hide or minimize your table

2) Create a container object that is no bigger than your screen resolution (i.e. there is no scrollbar as a result of this container)

3) Add your table to the container

I can't think of any other way to achieve this.

Re: Removing Scrollbar

senpradip007 — Tue, 03 Sep 2013 12:52:32 GMT

Hi Inna,

Instead of using the image in sheet property you can try the image in textbox object. Hopefully it will help your perpose.

Re: Removing Scrollbar

techvarun — Tue, 03 Sep 2013 12:58:53 GMT

This May Help

disable scrollbar in a pivot table

Regards

Re: Removing Scrollbar

Tue, 03 Sep 2013 13:01:02 GMT

There really isn't a way you can shrink the model enough to fit on to the screen and still be able read what's happening.

Rather minimise the object when its not in use and maximise when you want to see the deatil.

Or else break the model into several different smaller table so that is can fit in the screen. Split your dimensions.

Re: Removing Scrollbar

Tue, 03 Sep 2013 13:02:24 GMT

I think she doesn't want the scrollbar in the screen itself and not the pivot table...

Re: Removing Scrollbar

techvarun — Tue, 03 Sep 2013 13:08:53 GMT

Change the Scroll button and Scroll background color to application's default background color.

Hope it helps

Regards

Re: Removing Scrollbar

Tue, 03 Sep 2013 13:15:20 GMT

I am of the same opinion as @orsh_

Container helps

Re: Removing Scrollbar

rajeshvaswani77 — Tue, 03 Sep 2013 13:21:34 GMT

Hi Inna,

Ideally you should not have the scrolling. Normally the dashboards present the information in one single view. Its a good design practice not to have any scrolling until it is very much required. In your case I would suggest if you can logically group this information and come up with two tables put them in a container object with tabs. I am not sure if this suits your design/requirement. Just a thought. Alternatively if you are able to group them have one table at to and another at the bottom. Or on different tabs altogether. (Depends if the user does not want to see all the information at one view)

thanks,

Rajesh Vaswani

Re: Re: Removing Scrollbar

Tue, 03 Sep 2013 13:25:28 GMT

Hi Orsh,

it really helps!

But now I have a problem to control chart scroll bar. I can't see its rightest edge.

Please see attached.

Re: Re: Removing Scrollbar

Tue, 03 Sep 2013 13:26:48 GMT

Hi Rajesh,

the problem is I need all these columns in one table.

Inna.

Re: Removing Scrollbar

rajeshvaswani77 — Tue, 03 Sep 2013 13:35:18 GMT

You have placed it in the container and the size of your table is more than the size of the container. Reduce the width of the table. If possible remove from container, reduce the width and again put it back.

thanks,

Rajesh Vaswani

Re: Removing Scrollbar

Tue, 03 Sep 2013 13:42:35 GMT

This might help, try shrinking the screen to 75%. That just mught help...

Re: Re: Re: Removing Scrollbar

Tue, 03 Sep 2013 13:46:14 GMT

I use a macro to fit my applications to screen resolution and make them fit into the screen.

I dont have such big tables and probably you wont be able to read the data but maybe someone else can use it

Sub Zoom

ActiveDocument.GetApplication.WaitForIdle

ActiveDocument.ActiveSheet.FitZoomToWindow

End Sub

Used on "OnSheet activation" . Your Scrollbars will be removed but i guess you wont be able to read your charts

Re: Removing Scrollbar

antose — Tue, 03 Sep 2013 14:03:37 GMT

Hi!

I think one of your problems is that you have 18 dimension and I don't think you can't make the table smaller if the columns in the dimensions is wide. Illustrated by pic 1.

Solution: Make the columns for the dimensions smaller