Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
good idea Litwin
hey blitwin11
can you tell where have you call this macro i.e.on which action or trigger
Just add a button to your screen anywhere and call the macro from the action on the button.