Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
Just need some thoughts on creating document chaining when user opens a particular sheet by clicking on the sheet header (on sheet activate).
The open URL action is only available on button properties and not on the sheet triggers properties , has anyone else put a workaround on achieving this without using the button.
Many thanks
Hi Naweed,
Just a thought.
May be you can create one Button (You already told without using the Button, But just a try) . e.g Object ID : BU01
Actions : OpenURL
then, goto Sheet Properties -> OnActivateSheet -> Actions -> Run Macro ->
Put the Code Like..
Sub CHECK()
ActiveDocument.GetSheetObject("BU01").Press
End Sub
You can hide the Button in Layout Tab -> Conditional as '0'
Hi Settu
Many thanks for the reply, however its Ajax only so no macros otherwise the macro could have solved the issue.
The only way I can achieve this from a look and feel perspective is if I turn off the tab row and use buttons to navigate between sheets this way I can document chain giving the user the perception of just moving to another tab.
I'm still hoping I can find a resolution for a trigger on sheet open in ajaax
Go through following threads:
Passing Parameters in a URL and Document Chaining
Document chaining in Qlikview | Qlik Community
Hope this will help!!
Many Thanks Balraj
I don't have an issue with document chaining using the prescribed method. The issue is related to Sheet level triggers not having the Open URL action, hence looking for a workaround away from the standard methods to implement something similar in ajaax without using buttons.