topic Current selection box in QlikView

Current selection box

Anonymous — Tue, 21 Jun 2011 08:38:05 GMT

Is there a way to supress the horizontal scroll bar on a current selections box

Current selection box

Tue, 21 Jun 2011 09:17:18 GMT

Not that I'm aware of, but consider this, If you were able to supress the horizontal scroll bar wouldn't this invalidate the purpose of the current selection box. Namely keeping the user aware of the selections made to understand the meaning of the charts.

Current selection box

Anonymous — Tue, 21 Jun 2011 09:33:57 GMT

The intention is that there would be enough abbreviated info and the pop-up text would provide the rest

Current selection box

erichshiino — Tue, 21 Jun 2011 16:30:32 GMT

You can use a text box as a work-around.

You can use the expression:

=getcurrentselections()

Then, you adjust the size you need and go to object properties -> caption -> Help text and use the same expression there.

but I agree with Richard, this can make the be less useful than a current selection box with the appropriate space.

Regards,

Erich

Current selection box

Anonymous — Thu, 23 Jun 2011 10:50:38 GMT

Thanks, decided to stay with scroll bar

Current selection box

kji — Thu, 23 Jun 2011 11:24:36 GMT

You can make a macro that changes the column widths, and set them so low that the scrollbar disappears.

Actual values will of course depend on the size of you currentselections box

sub SetWidths

set cs = ActiveDocument.GetSheetObject("CS01")

dim w(2)

w(0) = 100

w(1) = 50

w(2) = 50

cs.SetPixWidths w

end sub