Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

samane_ramezani
Contributor

Setting Scrollbar to keep right by default in list box or straight table

Hi

I have list box and a straight table in my document  and want to keep Scrollbar at right by default in those objects

I found macro for line chart but did not work for list box or straight table

the macro is :

***********************************

sub OneOff

set chart = ActiveDocument.GetSheetObject("CH01")

set p = chart.GetProperties

p.ChartProperties.XScrollInitRight = true 

chart.SetProperties p

end sub

***********************************

Can anybody help me?

Thanks

4 Replies

Re: Setting Scrollbar to keep right by default in list box or straight table

This property is a chart-property which meant a listbox will be excluded. And although a pivot and a straight table belonged to the charts and will share many properties I don't believe this is also true for this setting.

- Marcus

samane_ramezani
Contributor

Re: Setting Scrollbar to keep right by default in list box or straight table

I know it does not work for list box or straight table and works for line chart.

I ask for macro which is work in list box or macro for straight table or a trick for keep scroll bar right

Re: Setting Scrollbar to keep right by default in list box or straight table

A macro could only access/manipulate an existing property and in this case there isn't such property documented and I doubt that there is an undocumented possibility.

This meant you need another approach to adjust the usability - maybe by changing the sorting in the objects and/or the order of dimensions/expressions and/or by splitting the objects into several smaller and more specialized objects.

- Marcus

samane_ramezani
Contributor

Re: Setting Scrollbar to keep right by default in list box or straight table

Thanks dear Marcus
Hope Qlik Tech solve this obvious problem

Community Browser