topic Re: lin b/w sheets in QlikView

lin b/w sheets

sonysree88 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: lin b/w sheets

Peter_Cammaert — Thu, 28 Jul 2016 16:18:47 GMT

Then what are you asking? What action should initiate the movement from sheet 1 to sheet 2?

Re: lin b/w sheets

NickHoff — Thu, 28 Jul 2016 16:19:34 GMT

If you label the object with the same Object ID found in the General tab of any object, they will automatically become a linked object. If you right click and copy the object, when you paste it you'll get the option to paste it as a linked objected as well.

Re: lin b/w sheets

maheshkuttappa — Thu, 28 Jul 2016 16:20:03 GMT

is this for navigation between sheet ? What do you want to achieve

Re: lin b/w sheets

sonysree88 — Thu, 28 Jul 2016 16:26:44 GMT

Here am giving Example Please check in the below link ,We have about this app and close links When you are click on that about this APP it will go for another shhet in the report here and if you can click on close it will close that window and again first page will open..

http://us-b.demo.qlik.com/QvAJAXZfc/opendoc.htm?document=qvdocs%2FSocial%20Media%20Buzz.qvw&host=demo11&anonymous=true

Re: lin b/w sheets

vishsaggi — Thu, 28 Jul 2016 16:35:17 GMT

Something like this?

Re: lin b/w sheets

Peter_Cammaert — Thu, 28 Jul 2016 16:37:12 GMT

The text box "about this app" will probably set a variable to some value that makes a set of hidden objects appear out of nowhere. The Close text will set the variable back to its initial value, making the objects in front go into hiding again. You can do all of this using text boxes and Conditional Show conditions (see the Properties->General tab in text object).

Best,

Peter

Re: lin b/w sheets

maheshkuttappa — Thu, 28 Jul 2016 17:15:01 GMT

Attached example with variable and show condition

Re: lin b/w sheets

sonysree88 — Thu, 28 Jul 2016 18:39:40 GMT

Hi Mahesh,

I am unable to open QVW file which you shared,I am using personal edition..

Can you please elaborate with screenshots if you possible

Regards

Sonysree

Re: lin b/w sheets

Peter_Cammaert — Fri, 29 Jul 2016 08:49:30 GMT

Ok, let's recreate this in the simplest way. You can add your own objects and variations once you master the technique.

Create a new QV Document
In Settings->Variable OverView, create a new variable called vShowOverlay and set its value to 1. Close the dialog.
On your Main sheet, create a text object with text "About this document" and a transparant background. On the caption tab, resize the object so that it is no larger than the text string. On the Actions tab, add action of type External->Set Variable, enter vShowOverlay in the Variable field and 1 in the Value field. Save and close the dialog.
Next to the new text ovject, create another larger text box with a white background. Do not put it in front of the first text object On the Layout tab, select Show Conditional and enter vShowOverlay = 1 in the expression field. On the same tab, set Layer to Normal. Save and close the dialog.
Again create a new text object on top of the white one. Put it in the top right corner. Make the background transparant and enter a text value of "CLOSE" or something. On the layout tab, select Show Conditional and enter vShowOverlay = 1 in the expression field. Set the Layer to Top . Add an action of type External->Set Variable, select variable vShowOverlay and set Value to 0. Save and Close.

All objects should be visible now. Click the "CLOSE" text...

Best,

Peter

Re: lin b/w sheets

sonysree88 — Fri, 29 Jul 2016 15:57:24 GMT

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

Re: lin b/w sheets

vishsaggi — Fri, 29 Jul 2016 16:18:07 GMT

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

Re: lin b/w sheets

Anil_Babu_Samineni — Fri, 29 Jul 2016 16:45:35 GMT

That's called Annotation.

Re: lin b/w sheets

Peter_Cammaert — Fri, 29 Jul 2016 18:38:02 GMT

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.

Re: lin b/w sheets

arunqlik2view — Tue, 26 Jun 2018 16:33:05 GMT

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