Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to Make link between the two sheets or 2 objects to go from one sheet to another sheet
Am not asking Buttons to go from one sheet to another sheet
Hi Peter,
Thanks for sharing the info
I tried with the above procedure which you shared but it does not work for me
just text boxes are created not to go for other sheets when i click on text object.
Regards
Sonysree
1. Create two sheets from Layout menu item and write down the sheetID's of these two sheets.
2. Create a Text object and name it as "About this App". Right click ->Properties -> Action Tab
-> Add ActivateSheet and Give the 2nd sheets sheet ID and click apply and ok.
3. Copy this Text object and paste it in the 2nd sheet. Create another text object (In the 2nd sheet)
and name it as Close. Right click on this text object -> Properties -> Actions tab
-> Add ActivateSheet and give the 1st Sheets sheet ID and click apply and ok.
4. Add some charts or any sheet objects you need in both the sheets.
5. If you do not want to show the tabs on top, just go to Ctrl+Alt+D Doc properties and
check Hide Tabrow.
6. Now toggle between the sheets with those text object links.
Let me know if this is what you are after...
That's called Annotation.
The example you supplied is done using text objects, NOT by changing sheets. I only exaplained how it is done.
Text objects can be used to simulate various other common navigation elements, like menus, tabbed dialogs, popup-windows etc.
Hi, This methods helps me to switch to the desired sheets but is there a way to switch to the desired sheet and a desired object in that sheet.
For example ,
- User is in SHEET 1
- Desired "Object 2A" is in SHEET 2 and the screen needs to be scrolled down to be at "Object 2A".
-------------------------------------------------------------------
Requirement :
Qlikview should automatically scroll down on SHEET 2 to be at desired object - "Object 2A".
-------------------------------------------------------------------
Steps I did :
- In the text object I added 2 actions
1. Activate Sheet
2. Activate Object.
Result:
Qlikview took me to the desired Sheet ( SHEET2 ) but I had to manually scroll down to see the desired Object ( Object 2A)
---------------------------------------------------
Please let me know if this can be done in Qlikview .
Thanks in Advance ,
Regards,
Arun