Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Freeze top of dashboard from scrolling away

Has anyone ever found a way to freeze the top of a dashboard from scrolling and allow the rest of the dashboard to scroll under it? We all have done this in excel, but I am looking for a way to implement this behavior in Qlikview.  This would most likely just be 3 or 4 buttons that don't scroll away.  Any ideas?

5 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

I'm assuming you are asking about QlikView, rather than Qlik Sense. I think there may have been a couple of QV Document Extensions that attempted this, don't know how successful they were. There is no way I know of without an extension.

-Rob

Not applicable
Author

I have come up with a work around.  I use macro's to move all of the sheet's objects (except objects on top which I want to be frozen). I then have a button on the dashboard which runs this macro.  One for scroll up , and one for scroll down.  It works best using the IE plugin, but I have found that is also works running AJAX. 

sub MoveObjectsDown

set sh = ActiveDocument.ActiveSheet

for i = 0 to sh.NoOfSheetObjects-1

    set obj = sh.SheetObjects(i)

    pos = obj.GetRect

    pos.Top = pos.Top + 30

    '  The below if statement will allow you to exclude objects from the move.   In this case all objects on the sheet move down except TX02 and TX03

    '  This give the scrolling effect

    if obj.GetObjectId <> "Document\TX02"  AND  obj.GetObjectId <> "Document\TX03"      THEN 

       obj.SetRect pos

    end if

next

end sub

sub MoveObjectsUp

set sh = ActiveDocument.ActiveSheet

for i = 0 to sh.NoOfSheetObjects-1

    set obj = sh.SheetObjects(i)

    pos = obj.GetRect

    pos.Top = pos.Top - 30

    '  The below if statement will allow you to exclude objects from the move.   In this case all objects on the sheet move down except TX02 and TX03

    '  This give the scrolling effect

    if obj.GetObjectId <> "Document\TX02"  AND  obj.GetObjectId <> "Document\TX03"      THEN 

       obj.SetRect pos

    end if

next

end sub

karthikeyan1504
Creator III
Creator III

good idea Litwin

Not applicable
Author

hey blitwin11

can you tell where have you call this macro i.e.on which action or trigger

Not applicable
Author

Just add a button to your screen anywhere and call the macro from the action on the button.

​​​​​