Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
sonysree88
Creator II
Creator II

lin b/w sheets

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

14 Replies
sonysree88
Creator II
Creator II
Author

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

vishsaggi
Champion III
Champion III

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...

Anil_Babu_Samineni

That's called Annotation.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Peter_Cammaert
Partner - Champion III
Partner - Champion III

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.

arunqlik2view
Creator
Creator

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